|
Excel 07 always showing formulas?
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? |
Excel 07 always showing formulas?
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? |
Excel 07 always showing formulas?
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? |
Excel 07 always showing formulas?
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? |
Excel 07 always showing formulas?
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? |
Excel 07 always showing formulas?
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? |
Excel 07 always showing formulas?
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? |
| All times are GMT +1. The time now is 03:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com