View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ivan ivan is offline
external usenet poster
 
Posts: 67
Default 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