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.

Ivan wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html