Cell references do not update
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
|