I have a workbook with 52 sheets for each week of the year. I have a link to
an 08 input sheet and and 09 input sheet. The problem is that on one of the
links from 09 input is pulling from cells c20 and c21, but the input sheet
has changed and the link should now pull from c32 and c33. Is there a way to
change the link? I have 52 sheets where this needs changing.
This is for 2003 Excel

Hi,

I would group the sheets from week 1 to week 52
(by selecting week 1 press SHIFT and then select week 52)
and then go to week 1 and make the changes nedded,
by grouping all sheets all changes are done on every sheet.

If there are more then one cell per sheet needing changes you
may use the find/replace tool after gouping all sheets.

Hope this helps!

Patrik


On Fri, 23 Jan 2009 08:17:01 -0800, Pammy
wrote:

I have a workbook with 52 sheets for each week of the year. I have a link to
an 08 input sheet and and 09 input sheet. The problem is that on one of the
links from 09 input is pulling from cells c20 and c21, but the input sheet
has changed and the link should now pull from c32 and c33. Is there a way to
change the link? I have 52 sheets where this needs changing.
This is for 2003 Excel