| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you print showing formulas in Excel 2000? | Excel Discussion (Misc queries) | |||
| Showing formulas | Excel Discussion (Misc queries) | |||
| Excel Formulas are showing relative address, rather than absolute | Excel Worksheet Functions | |||
| formulas showing not value | Excel Discussion (Misc queries) | |||
| How can I print my excel worksheet showing formulas in the cells? | Excel Worksheet Functions | |||
Hybrid Mode
