no formula bar

[looter]

My formula bar has completely disappeared.

Selecting formula bar in the drop down menu or preferences has no
effect. It is not shown with or without it checked in either.

Has always been there in the past.

Mac OS 10.2.8
Office 10.1.5

 

[J.E. McGimpsey]

My formula bar has completely disappeared.

Selecting formula bar in the drop down menu or preferences has no
effect. It is not shown with or without it checked in either.

Has always been there in the past.

Mac OS 10.2.8
Office 10.1.5

There's been a rash of this going around, but no obvious cause. if
you can reproduce this, please post back.

One way to fix it:

Type OPT-F11 to enter the Visual Basic Editor, then type CMD-g to
open the Immediate Window.

Type or paste the following two commands into the Immediate window,
following each with a Return:

Application.CommandBars("Formula Bar").Enabled = True

Application.CommandBars("Formula Bar").Visible = True

Type Opt-F11 to return to XL.

Another way:

With XL closed, trash the Excel Toolbars (10) file in the Microsoft
folder in the ~:Libraryreferences folder (where ~ is your home
folder). Empty the Trash. Start XL to recreate the file. Choose
View/Formula Bar if necessary.

 

[Mike]

J.E.
To recreate, grab the formula bar and drag it up to the Excel menu
bar and let go - it dissapears, just like magic, and even more
magical, cannot be made to reappear.

Thanks for the fix

Mike

 

[KC Horn]

JE --

I tried both your fixes and didn't have success.

Visual Basic didn't make any change. When I looked in my
folder-library-preferences, there wasn't a Microsoft file there to go
into.

I just switched back to Mac so don't feel adept yet but sure miss my
formula bar. As far as I know, it has been missing since day one. Any
light you can shed will be appreciated.

KC

 

[Bob Greenblatt]

JE --

I tried both your fixes and didn't have success.

Visual Basic didn't make any change. When I looked in my
folder-library-preferences, there wasn't a Microsoft file there to go
into.

I just switched back to Mac so don't feel adept yet but sure miss my
formula bar. As far as I know, it has been missing since day one. Any
light you can shed will be appreciated.

KC

I hesitate to even suggest this, but did you look in the view menu? Is
formula bar checked?

 

[Mark Wilkinson]

J.E.
To recreate, grab the formula bar and drag it up to the Excel menu
bar and let go - it dissapears, just like magic, and even more
magical, cannot be made to reappear.

I have had the same problem. After reading this posting I found that
the formula bar was hidden behind the 'standard' and 'formatting'
toolbars. Presumably I'd accidently dragged it up to the menu bar and
it became hidden after I had clicked a button on one of the other two
toolbars. To get it back, make sure formula bar is ticked in 'View',
close the other toolbars and you'll see it - or at least the bottom
half of it under the menu bar. Just drag it back down.

 

[KC Horn]

Bob:

Of course my formula bar was checked - I'm not that inept. Although
what actually did happen, you may assign to the inept category anyway.
My home icon on the desktop and my home folder within it have the same
name, so I couldn't find the right library folder and the toolbar 10
document to trash. Once I found it, it worked, and I have the formula
bar. Still wonder what I did wrong with visual basic, though.....

thanks,
KC