missing pivot toolbar

[neilb]

Hi

Please can anyone help. I have excel 2000 and have lost my pivot toolbar. If I go to view/toolbars it is ticked. I have lookedto see if it is hiding anywhere but can not find it.

Is there any where else it could be hiding or should I re install excel?

Many thanks

 

[earlyd]

Try View Toolbars Customize Reset

 

[neilb]

No this doesnot make it appear!

 

[neilb]

I just got an email that saays that I have had a reply. I clicked on the link and it states that the message doesn't exist???

 

[earlyd]

Try this macro (and stay calm) . If this doesn't help, I'm at a loss on this one.

Sub Macro2()

Application.CommandBars("PivotTable").Visible = True

End Sub

 

[neilb]

No this did n't work either! Its strange

 

[earlyd]

Did it run and not do anything or did it give you an error msg?

 

[neilb]

It ran but there was no visable difference

 

[earlyd]

I'll give it another shot...

Try running this...post back what happens

Sub Macro3()
Foundit = True
For i = 1 To 35
If Application.CommandBars(i).Name = "PivotTable" Then
Application.CommandBars(i).Visible = True
Application.CommandBars(i).Position = 4
Foundit = True
i = 35
End If
Next i
If Foundit = False Then
MsgBox "Did not find Pivot Table Toolbar"
End If

End Sub

 

[earlyd]

Use this instead!


Sub Macro3()
Foundit = False
For i = 1 To 35
If Application.CommandBars(i).Name = "PivotTable" Then
Application.CommandBars(i).Visible = True
Application.CommandBars(i).Position = 4
Foundit = True
i = 35
End If
Next i
If Foundit = False Then
MsgBox "Did not find Pivot Table Toolbar"
End If

End Sub