Hi,
I have a file with dozens of pivots split by several sheets. I need to change the data range that feeds the pivots from one sheet to another one.
Is there any easy (and above all fast) way of replacing the name of the range of all the pivots, without having to do it in each pivot?
Tia,
Ana
IF you post a sample workbook, then we can help you better. Read the yellow banner at the top of this sheet.
Based on you description of you want to do, I suggest that you develop the pivot table to read data from a named dynamic range. If you need to change the range, change the dynamic range to cover the new range.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
Thanks for the answer, dflak.
Given your help, the easiest way seems to be to replicate the file and replace the master data in the new one. I preferred to keep everything in the same file but this way I think I can solve this issue.
Thanks a lot for your help!
Have a nice week-end,
Ana
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks