Forum Discussion
Why does a downloaded spreadsheet not automatically calculate?
I have an Excel spreadsheet that was created using Office 2016 and the sheet that I created has formulas that reference blank cells. This sheet, which is attached, is set to automatically calculate i...
Allen
Community Manager
Community ManagerHi Chris,
Welcome to the Microsoft Tech Community, it looks like the calculation settings for your sheet have been changed to manual as a result it will only calculate when you press F10.
Calculation Options
If you select formulas from the ribbon then on the right hand side click calculation options you will see its set to manual. Change it to automatic and you should be all set.
Hope this helps.
Thanks, Allan. I checked and it was set on Automatic Calculation. I'm now wondering if it has something to do with Google Drive, which is where we hosted it for them to download.
