pivot table toolbar missing from toolbars menu

  • Thread starter Thread starter Jan Price
  • Start date Start date
J

Jan Price

I have a user who frequently uses pivot tables in Excel.
The pivot table option is missing from his View|Toolbars
menu.

We're running office xp in a windows xp environment.

I've run the repair and the reinstall utility - toolbar is
still missing.

How can I get it to display for him?

Thanks!

Jan
 
Jan,

Try running this little macro on his machine:

Sub ShowPivotTB()
With Application.CommandBars("PivotTable")
.Reset
.Enabled = True
.Visible = True
End With
End Sub

HTH,
Bernie
MS Excel MVP
 
Back
Top