Excel 07 always showing formulas?

[Steve]

I have a user using excel 07 who, all of a sudden, has spreadsheets that open
with the formula values showing. She turns them off by CTRL + `, but is
annoyed at having to. Any thoughts on how to turn this default back?

 

[Ron de Bruin]

Hi Steve

Office button > Excel options...Advanced
See Display options for this sheet

After you change it save the file

 

[Steve]

Hi Ron...Thanks...is there a way to do this universally for every opened
sheet though?

Thanks!

 

[Ron de Bruin]

Hi Steve

It is a worksheet setting not a workbook setting
Do you say that every sheet in every workbook have this problem.

Do you use xls files or 2007 files (xlsx, xlsm)

 

[Steve]

From the user's report - this happens sporadically and typically 07 files are
used.

Thanks

 

[Ron de Bruin]

Hi Steve

I never hear about this problem
Changing the view and saving the workbook is the only way I think

 

[Gord Dibben]

Try selecting all sheets before changing the setting.


Gord Dibben MS Excel MVP