Can't you highlight the sheet and use CTRL-H (Find and Replace) to:

Find What: Jan.xls
Replace With: Feb.xls

then click Replace All? You seem to be suggesting that you currently
change all the references manually.

Hope this helps.

Pete

California Phil wrote:
Tough one...I have a "Socrecard" spreadsheet that is loaded with links to
other "data source" spreadsheets. Each month, I have to open each cell and
change the pointer from, for example, ='G:\2006\[Jan.xls]CONSOLIDATED
VIEW'!$CR$64 to ='G:\2006\[Feb.xls]CONSOLIDATED VIEW'!$CR$64. For now, I can
use CNTL F and the find feature to search for Jan, then replace with Feb, but
I would like to have one page of the excel SS with Jan, Feb, Mar, etc and
have the cell point to it like this ='G:\2006\[POINT TO CELL
HERE.xls]CONSOLIDATED VIEW'!$CR$64. Possible???