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