Forum Discussion

Copper Contributor

Nov 02, 2019

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 ...

Excel Online

PReagan

Bronze Contributor

Nov 02, 2019

Hello ChartreuseBison,

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

ChartreuseBison

Copper Contributor

Nov 02, 2019

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

PReagan
Bronze Contributor
Nov 02, 2019
ChartreuseBison

Wonderful. Go into File, then Options, then the Formulas Tab, and ensure that Workbook Calculations are set to Automatic.
- ChartreuseBison
  Copper Contributor
  Nov 02, 2019
  PReagan
  
  Does this option exist in Office online? I do not have Office installed right now
  - PReagan
    Bronze Contributor
    Nov 02, 2019
    ChartreuseBison
    
    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