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