Missing Pivot Table Toolbar

acooper

New Member
Joined
Nov 24, 2005
Messages
2
I have lost the pivot table toolbar and I can not recover it. Along with the toolbar, I have also lost the field list. I have tried to turn it on and off, but it does not return. When I right click on the menu bar and select it, the check mark shows up indicating that I should have it, but it does not show up.

I would greatly appreciate any help as I use pivot tables every day. I do not know how I lost it, but without it I have to add and remove fields with the wizard and the layout button. That is very difficult to work with.
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

Tom Urtis

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,222
Just for starters, try running this macro and see if it helps.


Sub ResetMenuBars()
Dim objBar As MenuBar
For Each objBar In MenuBars
objBar.Reset
Next objBar
With Application
.CommandBars("Worksheet Menu Bar").Visible = True
.CommandBars("PivotTable").Visible = True
End With
End Sub
 

acooper

New Member
Joined
Nov 24, 2005
Messages
2
Thanks for the VB code, but I still had no luck. I wonder if I have something currupted.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,760
Messages
5,574,084
Members
412,566
Latest member
TexasTony
Top