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.
If you remove connection only, not entire query to list, data shall be kept.
ok...so it's just as simple as that !...thanks !!!
If i can ask something more.... I just did in a normal XLSX file where I have simple data and it works but... when i try to do the same with Pivot Tables, data still disappears.
Would you have any idea how i could do it for Pivot Tables ?
Thanks a lot !!
That's another story. If you connect Table to the list, data is kept in the grid, with removing of connection you only won't be able to update it.
With PivotTable data is on SharePoint, removing the connection you remove data. Actually I don't know hoe to resolve. Depends on which PivotTable you use data could be kept in PivotTable cache or in data model. If you disable all possible options to refresh PivotTable (without removing the connection) it is some chance data will be kept in caches if you do nothing with such files. That's easy to test.
- Hi SergeiBaklan,
Sorry for my late reply.
Not sure i know how to do that 😛
When you say "Data Model" it's the file that is stored locally on my computer isn't it ? So that means i should put it in my SharePoint library...
Isn't the Pivot table cache activated by default so the data would not disappear ?
Now i'm thinking about something , Since I have a file with all the data (the one where i removed the connections) and the additional file with the PivotTables only, isn't it possible to simply "switch" the data connection from SharePoint to the other file ?
Thanks a lot !!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.