Cell references do not update

I

Ivan

Hi,

I've got a book with about 200 sheets, the 1st worksheet has quite a few
formulas with references to cells in the other sheets.

Everything used to work fine but since a month ago I've realised that if a
move the position of a sheet inside the book, the formulas with references in
the 1st sheet do not automatically update their value when cells in the sheet
that has been moved change their value

Any suggestion?

Cheers
 
A

Anne Troy

Ivan: I'm not sure I understand your question. Why would your cell values
change just because you "moved" a worksheet. Perhaps you can define "move"
for us. Are you moving to another workbook?
 
D

Debra Dalgleish

If you used 3D references, perhaps you've moved the sheet outside the
group of sheets being summed. For example, the formula on the summary
sheet may be: =SUM(Sheet1:Sheet200!B5)

If you moved Sheet2 to the left of Sheet1, it's values are no longer
included in the sum.
 
I

Ivan

Hi Anne,

I've got sheets like productA, productB, ProductC (alphabetically sorted). I
also have some sheets hidden of products I don't frequenly use. Sometimes I
need to add an extra productX sheet to the book and after sometime I have
unhidden some product sheet because I need to use them again. When I unhide
one sheet it many not appear in the position i like because i have added
other sheets so i move(reposition) it inside the book to get the full book
again alphabetically sorted. This is the time I start getting problems.

The cell values do not change because i move one sheet. They change because
i may a change in some cells of the sheet. The summary sheet adds certain
values of each sheets.

As Debra suggested, this is not the case as i do not use the SUM formula in
the summary sheet because each individual sheet has a totally different name

Hope this explain my case a bit better

Please feel free to ask me anything you may not understand

Thanks in advance
 
I

Ivan

just to be more precised, a cell with the reference ProductX!C5 located in
the summary sheet will not update its value automatically if the cell C5 of
the sheet ProductX changes.
 
Top