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?
--
~Anne Troy
www.OfficeArticles.com
"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