I have one 52 spreadsheets that are linked (example: sheet 1 - Precinct
workb to sheet 1 Compstat master workb. There are 52 spreadsheets on both
workbooks and 1 pulls from 1, 2 from 2, etc all the way to 52. Problem,
several rows were added to the master so now the formulas for the compstat
master are off is pulling the wrong row of the precinct workb. Is there an
easy way to update the correct formula information into the new cells of the
master, keeping in mind 1 is linked to 1, 2 is linked to 2, etc all the way
for 52 worksheets. To do this manually for 52 sheets will be so time
consuming. I have excel 2003.
Thank you.

select all worksheets. changes made to oe will change in all.

"Pammy" wrote:

I have one 52 spreadsheets that are linked (example: sheet 1 - Precinct
workb to sheet 1 Compstat master workb. There are 52 spreadsheets on both
workbooks and 1 pulls from 1, 2 from 2, etc all the way to 52. Problem,
several rows were added to the master so now the formulas for the compstat
master are off is pulling the wrong row of the precinct workb. Is there an
easy way to update the correct formula information into the new cells of the
master, keeping in mind 1 is linked to 1, 2 is linked to 2, etc all the way
for 52 worksheets. To do this manually for 52 sheets will be so time
consuming. I have excel 2003.
Thank you.

This changes all the sheets to the one I happen to be on. I am on sheet 1
and select all the sheets then the only change I make is changing the G33 to
J21 it changes all the sheets to the cell ref of J21 which is correct, but
now all the sheets are pointing to sheet 1. This is my formula:
=SUM('[09 input.xls]1'!G33) (example) So when I am on sheet 2 it should
now read: =sum('[09 input.xls]2'!J21) but all 52 sheets are 1.
Thanks,

"daniel" wrote:

select all worksheets. changes made to oe will change in all.

"Pammy" wrote:

I have one 52 spreadsheets that are linked (example: sheet 1 - Precinct
workb to sheet 1 Compstat master workb. There are 52 spreadsheets on both
workbooks and 1 pulls from 1, 2 from 2, etc all the way to 52. Problem,
several rows were added to the master so now the formulas for the compstat
master are off is pulling the wrong row of the precinct workb. Is there an
easy way to update the correct formula information into the new cells of the
master, keeping in mind 1 is linked to 1, 2 is linked to 2, etc all the way
for 52 worksheets. To do this manually for 52 sheets will be so time
consuming. I have excel 2003.
Thank you.