Hi Steve

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
From the user's report - this happens sporadically and typically 07 files are
used.

Thanks

"Ron de Bruin" wrote:

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)


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
Hi Ron...Thanks...is there a way to do this universally for every opened
sheet though?

Thanks!

"Ron de Bruin" wrote:

Hi Steve

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

After you change it save the file



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Steve" wrote in message ...
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?