Pivot Table refresh on SharePoint files
We have a user at my office that had to move a file out of SharePoint because it would not function correctly when it was there. The file now resides on Huddle because of a pivot table refresh problem.
She has references in the pivot table that reference the same worksheet, however whenever she saves the document the link she creates changes from this Sheet:B3 etc. to https://almondgateway.sharepoint.com/...... This is causing problems because when data is changed locally the pivot tables don't refresh properly. They still hold the old data and none of the updated data.
I was at the SharePoint conference this week and this is what the OneDrive engineers recommended that I put in the ticket so that we can get it resolved.
They also said mention the key words: TAKEN OUT OF SHAREPOINT, and PUT ON HUDDLE instead.
thanks so much for being so helpful.