Changing Multiple Pivot Ranges

S

SJ Joshua

Please help:

I have about 330 pivots (yeah, it's a lot) on six different tabs whose
source data (range) is located in two different files.

My Excel crashed and after I accepted the auto-save updates, the range
addresses changed from being located in the same folder (where my
pivots are located, [Filename.xls]Sheet1!$A$1:$ZZ$62000) to being the
entire address (C:\Documents and Settings\user\applications\etc...).

I tried in Edit->Links to 'relink' the correct files; however, when I
re-open the file, it continues to reference the entire address.

How can I effeciently change all of the range addresses?

Thanks,

Joshua
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2013 Pivot Data Range formula reference problem 0
Multiple Tables and Multiple Pivot Tables Help 0
selecting cells to produce a pivot table 4
Dynamic Pivot - invalid data range 0
Easy way to change Pivot table source files? 5
Change all ranges in the Pivot Table 2
Excel 2007 Pivot Table Changes the Source Data Range 1
Corrupt files due to pivot remnants after saving via VBA 0

Top