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...
In addition, Calculation mode is applied to any workbook opened, not to concrete one. Attached to the post workbook is calculated automatically without any problems.
The question is about stats - if the workbook was distributed to one-two persons who are in same business that only means they use manual mode working with Excel. If dozens of people to whom the workbook was distributed have the same issue that's another story. Low probability all of them are in manual mode by default. At the same time for me it's hard to imagine what could be the reason for such behaviour.
In brief, most probably that's not this concrete workbook issue but setting on users site.
Allen
Community Manager
Community ManagerThanks! and just to add - You could add a macro into the spreadsheet that would force automatic calculation but macro enabled workbooks require user interaction to enable macros and some users may not thank you for overriding their personal settings.