Linking to other spreadsheets - complex formula
 

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???

Linking to other spreadsheets - complex formula
 

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???

Linking to other spreadsheets - complex formula
 

The problem is that the page has multiple links to about fifteen different
spreadsheets, so I would have to use the FIND feature repeatedly for each
file. This may end up being my only option, but having it link to a single
page where all the file names are listed and making the change there would
ensure I capture all the links versus checking each highlighted cell
(highlighted in blue to help me remember which have links) and then
determining what links to update.

"Pete_UK" wrote:

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???