Forum Discussion
Removing connections to SharePoint lists
Both are kept within Excel file. If you don't know about data model most probably you don't use it, details are here Create a Data Model in Excel (microsoft.com)
Without data model PivotTable creates copy of the source data in local cache and works with it. It updates the cache on each refresh from data source. Understanding the Excel PivotTable Cache – (bluepecantraining.com)
I'm not sure you can change PivotTable data source from one connection type to another, but my practical experience here is quite limited.
Both are kept within Excel file. If you don't know about data model most probably you don't use it, details are here Create a Data Model in Excel (microsoft.com)
Without data model PivotTable creates copy of the source data in local cache and works with it. It updates the cache on each refresh from data source. Understanding the Excel PivotTable Cache – (bluepecantraining.com)
I'm not sure you can change PivotTable data source from one connection type to another, but my practical experience here is quite limited.
