Forum Discussion
Pivot table data source not staying within the file
mathetesbut that's the problem. If you save the file after doing work and put a new description on the file the pivot table then looks to the old file for the dataset it doesn't keep the connection within the current file being worked on. It's crazy that every time I do a 'save as' and rename the file I then have to go and change all the data sources of the pivot tables to look at the new file and not the previously named file. make sense?
It does make sense.
And after following the thread that @EMcil82 gave, I see it's not a new problem, nor one that's easily resolved. I had missed in the first instance that you were getting data from a different spreadsheet (different file).
I've had similar issues with a workbook I created that pulls data for financial analysis from a daily download from a brokerage....there've been occasions when I've moved from one computer to another with those files in 'the cloud" and then gotten all kinds of error conditions when I'm expecting my main analytical sheet to link with the fresh downloads. Frustrating, to be sure. Even when it looks to me as if all files are within the same folder, on the same desktop....
So I feel your pain, but have no ready solution either.