Try selecting all sheets before changing the setting.


Gord Dibben MS Excel MVP

On Tue, 18 Mar 2008 09:53:09 -0700, Steve
wrote:

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?