I have an excel document with pivots graphs and tables in reports library. I wanted to that the excel document should automatically get the data from the list via a data connection. Is there a way to do this without doing an export to excel in the list actions? If I can get the data to pull into excel automatically, then I don't have to though and create the graphs all the time.
So bottom line, I have an excel file that I need to map the fields in to the
fields in a sharepoint list in real time.