View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default How to suppress auto-calculation when opening an older version fil

All of mine are set to auto calculate but, as I recall, excel will
automatically take the calculation mode of the FIRST workbook opened.

--
Don Guillett
SalesAid Software

"David" wrote in message
...
If one opens an Excel file in version XP that was saved using a previous
version, Excel will recalculate all cells.

Is there a way to suppress this or turn it off?
David