Hidden Formula Bar

  • Thread starter Thread starter James
  • Start date Start date
J

James

When I open EXCEL, the formula bar is missing. I can reenable it be going to
Tools->Options->Formula Bar
but next time I log onto the computer the bar is gone again.


Any suggestions?
 
You are correct in that I would be able to activate the formula bar this way.
However, I still would have to do this every time I use the program. I am
looking for a way to ensure that EXCEL remembers that I would like the
formula bar active every time I use the program.
 
If you open a file by double-clicking an icon, Excel will pickup the options
stored with the file:

1. open Excel (no file)
2. enable the formula bar
3. open a miscreant file with File > Open
4. the formula bar will remain
5. save the miscreant file
 
View>Formulas is an application setting, not a workbook setting.

Setting is stored in the Registry

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options

Right-side window select "Options".

Value should be decimal (87) for view>formulas enabled.

(85) for disabled.

Perhaps OP does not have permissions to save to the Registry?


Gord Dibben MS Excel MVP
 
Back
Top