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