quickly updating a large group of formulas

**fantom06** · 04-01-2009, 07:27 AM

I have a spread sheet that has links to other spread sheets throughout the year. Well as the new year came I had to completely rewrite it for the new year. I'm trying to figure out a way to not have to do this again at the end of the year as it takes a couple of hours to edit the whole thing completly.

Here is how I currently have it setup:
b5
=+'C:\Documents and Settings\Administrator\My Documents\spreasheets\2009\[03-31-09.xls]SALES'!$C$25
c5
=+'C:\Documents and Settings\Administrator\My Documents\spreasheets\2009\[03-31-09.xls]SALES'!$C$29
b6
=+'C:\Documents and Settings\Administrator\My Documents\spreasheets\2009\[04-07-09.xls]SALES'!$C$25
c6
=+'C:\Documents and Settings\Administrator\My Documents\spreasheets\2009\[04-07-09.xls]SALES'!$C$29

and so on
what I would like to be able to do is to tell it what weeks to look for and it know where to find them. that way at the end of the year I only have to tell it the weeks and it changes all the formulas in the master copy. Is this possible or am I too wishful?

Thanks

**dominicb** · 04-01-2009, 08:12 AM

Good afternoon fantom06

...and welcome to the forum!!

Originally Posted by fantom06

what I would like to be able to do is to tell it what weeks to look for and it know where to find them. that way at the end of the year I only have to tell it the weeks and it changes all the formulas in the master copy. Is this possible or am I too wishful?

Not at all. With your spreadsheet open go to Edit > Links. This will open a dialog box that will show the names of any files to which the current workbook is linked. Just alter these by clicking on the Change Source button.

HTH

DominicB