Excel Worsheet/Workbook formula links

[CrossCutter]

I am setting up spreadsheets for 2009 and I am using spreadsheets from 2008.
1 spreadsheet is a monthly summary of items done weekly and is associated to
3 other woorkbooks. I changed the names of the 2009 copies and now none of
the links to the other 3 spreadsheets work. Is there a fast way of
associating these workbooks again, without haveing to reenter all the
formulas again.
I would appreciate any help.

Thanks
CrossCutter

 

[Gord Dibben]

Try Edit>Links>Change Source.

You must do this for each of the source worbooks you find under Edit>Links.

3 changes will do it.

You may have to change cell references from absolute to relative depending
upon how you first linked.


Gord Dibben MS Excel MVP