User Profile
EMcil82
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: 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?5.9KViews0likes2CommentsPivot table data source not staying within the file
Hi I've got a lot of pivot tables working of a large dataset all in one excel file. Only issue is that as I save the file on diff dates I want version control but the pivot tables then keep looking at the original data source file when it was first created they don't just keep referring to the tab within the file. I'm not changing tab names or anything else just the file name. Is there an easy was to update the pivot tables so it stops looking externally for the data source? I don't want to apply a macros but this is really annoying given the number of pivot tables in the file6.1KViews0likes4Comments
Recent Blog Articles
No content to show