Forum Discussion
Why does a downloaded spreadsheet not automatically calculate?
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.
Thanks, Sergei. I checked with a couple of the recipients and they said their Excel settings were set to Automatically Calculate and not Manual. Do you think it could it have something to do with them downloading it from Google Drive?
Chris, I'm not sure. If you could share your file on Google Drive we may test.
- Allen
Community Manager
Thanks! 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.
