Thread: formulas quit calculating
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
  
Posts: 524
Default formulas quit calculating
Mon, 7 May 2007 15:21:02 -0700 from spence
:
I just stumbled across a BIG problem with a number of spreadsheets: all their
formulas have stopped calculating. If I unprotect the sheets, put the cursor
at the end of the formula in a particular cell, and then hit "enter," the
formula calcuates, but only if I do this in each cell that contains a
formula.

Tools | Options | Calculation | Automatic

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/
Reply With QuoteReply With Quote