Help,
I have about 30 pivot tables that all link to a workbook in the same folder, so the source data path is just the filename and range. Both files are on a network drive.
Today when I opened the pivot table file, all the pivot tables have had their source data changed to be the Autorecover location on the C: drive
Any ideas as it's a pain to have to go through manually 30 times and change the source data and I'm guessing it may happen again.
Thanks
Welcome to the Board, however, please note:
Your post does not comply with Rule 8 of our Forum RULES.
Cross-posting is when you post the same question in other forums on the web (eg MrExcel)
You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere.
We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.
Read this to understand why we ask you to do this
Please edit your prior post and add any/all cross post links.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks