View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa Lisa is offline
external usenet poster
 
Posts: 328
Default Help!Excel will not calculate formulas- Not in manual calculation

Hello,

Suddenly my formulas are no longer calculating and when I verify
OptionsCalculation, I am in Automatic mode for calculating formulas. F9 does
not work and by switching automatic calculation on and off it does not change.

Also, it seems to depend on the cell. On the same sheet I can have one cell
that calculates a formula and another that does not.

There is no visual basic in my spreadsheet.

Any ideas?

Lisa