Forum Discussion
All cells with Formulas showing up blank in read-only view
I have a workbook that I share with several other people in read-only mode in Excel Online. When they open the page, any cell with a formula just shows blank. Even simple ones like =Now(). If I open ...
PReagan F9 does show it, how do I make that the default again?
Wonderful. Go into File, then Options, then the Formulas Tab, and ensure that Workbook Calculations are set to Automatic.
PReagan
Does this option exist in Office online? I do not have Office installed right nowUnfortunately, I am not very familiar with the options that are available in Excel Online. I did find this possible solution online but upon testing the solution I could not find this option. Maybe it is available for you?
https://answers.microsoft.com/en-us/msoffice/forum/all/auto-calculate-on-excel-online/503a7c90-fcc8-401c-b117-7af54cc0fa4f