formula bar missing

[Ralph]

I have Office V.x and recently downloaded upgrades10.1.2, 10.1.4 and
10.1.5. I now don't have a formula bar. I have tried "preferences",
"view" and reinstalling but nothing works. I went back to no upgrades
and reinstalling just to get the formula bar back. I am running Jaguar.

 

[J.E. McGimpsey]

I assume by "view" you mean you tried the View/Formula Bar toggle,
right? And by "preferences" you mean you've deleted the Excel
Toolbars (10) preference file and the Excel Settings (10) preference
file in the ~:Libraryreferences:Microsoft folder (where ~ is your
home directory), right?

Try this:

First, choose Tools/Customize. On the toolbars tab, scroll down and
select the Formula Bar item in the textbox. Click Reset and ensure
the checkbox is checked. Click OK - is it back?

If not, type Opt-F11 to get to the Visual Basic Editor. Type CMD-G
to open the Immediate Window.

Type or paste in

Commandbars("Formula Bar").Enabled =True

hit return, then type or paste in

Application.DisplayFormulaBar = True

and hit return. Type Opt-F11 again to return to XL.

The formula bar should now be displayed. If not, post back.

Close XL and reopen - is the Formula Bar visible? If not, you may
have a macro running in a file in your Startup Folder (Microsoft
Office X:Office:Startup:Excel that disables it.

 

[J.E. McGimpsey]

I have Office V.x and recently downloaded upgrades10.1.2, 10.1.4 and
10.1.5. I now don't have a formula bar. I have tried "preferences",
"view" and reinstalling but nothing works. I went back to no upgrades
and reinstalling just to get the formula bar back. I am running Jaguar.

Couple more things:

First, when you reinstalled, did you run Remove Office from the
Value Pack folder of the installation CD first? Just trashing the
Microsoft Office X folder won't necessarily clean everything up.

Second, you should also make sure you repair permissions after
installing/applying updates:

Run the Disk Utility (in the ./Applications/Utilities folder). From
the First Aid tab, click "Repair Disk Permissions".