eyepods
New Member
Hi All.
I have been plying with Pivot tables and dashboard to present info from a flat excel spreadsheet. My question is, how can I access a data fields from a number of spreadsheets (via SharePoint, etc)
At the moment i simply export data to a spreadsheet and create a pivot table, each time I need to update the table I have to run an export again and re-create the pivot table..... any help appreciated.
I have been plying with Pivot tables and dashboard to present info from a flat excel spreadsheet. My question is, how can I access a data fields from a number of spreadsheets (via SharePoint, etc)
At the moment i simply export data to a spreadsheet and create a pivot table, each time I need to update the table I have to run an export again and re-create the pivot table..... any help appreciated.