Try EditLinksChange Source.

You must do this for each of the source worbooks you find under EditLinks.

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

On Mon, 8 Dec 2008 16:25:00 -0800, CrossCutter
wrote:

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