Excel Formulas - Disabled

Question

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

lisa bain · Answer

Haytham to the rescue....thank you!

renee nichols · Answer

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

haytham amairah · Answer

Hi Lisa,&nbsp;It seems that the calculation option is set to manual!So, please go to Formulas &gt;&gt; Calculation &gt;&gt; Calculation Options &gt;&gt; Automatic&nbsp;Regards

goitseone humangwa · Answer

Hi,&nbsp;I am trying to create a PivotTable. When copying a cell from the Table, some Pivot fields are missing.&nbsp;&nbsp;Please help.

haytham amairah · Answer

Hi Goitseone Humangwa&nbsp;Could you post this question in a separate conversation rather than here? because this conversation isn't related to what you asking for.So, please start a new conversation from here.

Forum Discussion

Excel Formulas - Disabled

5 Replies

Resources