Hi all,
I need some help with linking workbooks, please. Here is the question in
bullet points so you dont get confused:
- I have 10 spreadsheets each one is saved on a different server.
- Each one of these 10 spreadsheets has 2 worksheets: €˜Main Data and
€˜Summary
- The €˜Summary worksheet has cells linked to other cells in the €˜Main Data
worksheet. For example: cell B8 in €˜Summary has the following formula:
='Main Data'!$BT$123
- I created a new spreadsheet and called it €˜Master
- I went to each €˜Summary worksheets in the other 10 spreadsheets and
created a new copy of each one of them in €˜Master (So 'Master' has 10
worksheets - a copy of each 'Summary')
- Things worked so good for a while. For example, the value in cell B8 in
the €˜Summary (in €˜Master as well as in the original spreadsheet) gets
updated every time the value in €˜Main Data!BT123 changes.
- However, my happiness didnt last long. The moment I added a new row in
the €˜Main Data worksheet. The following happened:

When a new row is added to €˜Main Data and cell BT123 gets shifted one step
down, this gets updated automatically in the €˜Summary worksheet located in
the same spreadsheet and the formula in B8 then becomes as follows: ='Main
Data'!$BT$124

However, the correspondent €˜Summary in the €˜Master doesnt get updated the
same way. The formula in there remains linked to cell BT123 instead of BT124.

What am I doing wrong?
Im using Excel 2003.
I would really appreciate any help or any clues or any other solution to
enable me having the 10 summaries in a separate spreadsheet.
Tendresse