Jun 19 2018 02:53 PM
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?
Jun 19 2018 07:28 PM
Hi Lisa,
It seems that the calculation option is set to manual!
So, please go to Formulas >> Calculation >> Calculation Options >> Automatic
Regards
Jun 20 2018 11:10 AM
Hi,
I am trying to create a PivotTable. When copying a cell from the Table, some Pivot fields are missing.
Please help.
Jun 20 2018 07:03 PM
Jun 21 2018 08:54 AM
Thank you so much, I had the same issue and I was so frustrated.