Greetings,
I have an Excel worksheet that pulls data from a SharePoint list, and then uses PivotTables on different worksheets to summarize the data.
The query to SharePoint is set to refresh automatically each time the worksheet is opened, and this seems to work.
However, the PivotTables are also set to refresh automatically each time the workbook is opened, and this does *not* seem to work. New values from SharePoint show up in the data source worksheet, but they are not added to the PivotTables until I right-click and select "Refresh" manually.
The option to automatically refresh on open is checked for each PivotTable.
Is it possible that the PivotTable is refreshing before the data-pull from SharePoint is complete? Is there a way to set the order of refreshment (hah!) so that the data source is refreshed before the PivotTables are refreshed?
Thanks,
Rachel
I have an Excel worksheet that pulls data from a SharePoint list, and then uses PivotTables on different worksheets to summarize the data.
The query to SharePoint is set to refresh automatically each time the worksheet is opened, and this seems to work.
However, the PivotTables are also set to refresh automatically each time the workbook is opened, and this does *not* seem to work. New values from SharePoint show up in the data source worksheet, but they are not added to the PivotTables until I right-click and select "Refresh" manually.
The option to automatically refresh on open is checked for each PivotTable.
Is it possible that the PivotTable is refreshing before the data-pull from SharePoint is complete? Is there a way to set the order of refreshment (hah!) so that the data source is refreshed before the PivotTables are refreshed?
Thanks,
Rachel