All cells with Formulas showing up blank in read-only view

Question

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 the book myself it updates and then shows up proper in read-only view, but after awhile they show up blank again.

The workbook is being written to by an external script but everything showed up fine for months, this problem only showed up in the last week or so.

preagan · Answer

Hello&nbsp;ChartreuseBison,&nbsp;When the worksheet shows all cells with formulas as blank, press F9. Does this show values in the empty cells?

chartreusebison · Answer

PReagan&nbsp;F9 does show it, how do I make that the default again?&nbsp;

preagan · Answer

ChartreuseBison&nbsp;&nbsp;Wonderful. Go into File, then Options, then the Formulas Tab, and ensure that Workbook Calculations are set to Automatic.

chartreusebison · Answer

PReagan&nbsp;Does this option exist in Office online? I do not have Office installed right now

preagan · Answer

ChartreuseBison&nbsp;&nbsp;Unfortunately, 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

Forum Discussion

All cells with Formulas showing up blank in read-only view

5 Replies

Resources