Excel Formulas - Disabled

Copper Contributor

I have several very simple detailed spreadsheets that contain formulas that are not computing.  I have to press F2 on each line for the formula to compute.  This started a little over a week ago just out of the blue.  It seems like my formulas have been disabled.  How can I fix this without having to recreate these spreadsheets?

5 Replies

Hi Lisa,

 

It seems that the calculation option is set to manual!

So, please go to Formulas >> Calculation >> Calculation Options >> Automatic

 

Regards

Haytham to the rescue....thank you!

Hi,

 

I am trying to create a PivotTable. When copying a cell from the Table, some Pivot fields are missing. 

 

Please help.

Thank you so much, I had the same issue and I was so frustrated.