In previous versions of Excel, I could easily manipulate links by using
the copy/paste and find/replace functionality.

For example, I have the link
='[07-05ApprovedAPSourcingDecisionsWithSQData.xls]Charts by
CommData'!$B15 in one cell and the link
='[08-05ApprovedAPSourcingDecisionsWithSQData.xls]Charts by
CommData'!$B15 in the one below. As you can see, the link is changing
the file name with the reference to the same cell in each file (I have
a file for each of the 12 months). I copy and paste that to the next
column and it prompts me for the file location of each cell!!! I
thought that maybe I need to open the files, but it still prompts me.
Once I go through all of the locations to get a new column of links, I
then need to change the $B15 reference to $B16. I tried to use a
simple find/replace and I am stuck selecting the file locations for
each change AGAIN. This is NOT efficient at all!

Is there a setting that can fix this? I just recently upgraded to
Office 2003, so I may be ignorant on this...

Any suggestions are greatly appreciated!!