Forum Discussion

Copper Contributor

Jun 19, 2018

Excel Formulas - Disabled

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...

excel

Formulas and Functions

office 365

Haytham Amairah

Silver Contributor

Jun 20, 2018

Hi Lisa,

It seems that the calculation option is set to manual!

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

Regards

Renee Nichols
Copper Contributor
Jun 21, 2018
Thank you so much, I had the same issue and I was so frustrated.
Goitseone Humangwa
Copper Contributor
Jun 20, 2018
Hi,

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

Please help.
- Haytham Amairah
  Silver Contributor
  Jun 21, 2018
  Hi Goitseone Humangwa
  
  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.
Lisa Bain
Copper Contributor
Jun 20, 2018
Haytham to the rescue....thank you!