Hidden Formula Bar

[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?

 

[Gary''s Student]

View > Formula Bar

 

[James]

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.

 

[Gary''s Student]

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

 

[Gord Dibben]

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