Enable the Toolbar on a Pivot Table

[Chris Jones]

I can't seem to get a Pivot Table Toolbar enabled. For a
while I worried that it had to do with ViewOnly mode, but
I have the appropriate licenses on my machine (see
details below).

What am I doing wrong?

I'm using OWC 10.0.0.4109, IE 6.0.2800.1106 on Windows XP
Professional. I Have MS Office 10 installed. E.g., here's
the version info for Excel:

Application name Excel
Version 10.
Build 4302


My VBScript code that initiallizes the PivotTable control
sets the following flags as indicated:

PTable.AllowPropertyToolbox = True
PTable.DisplayPropertyToolbox = True

PTable.AllowGrouping = True
PTable.AllowDetails = False
PTable.AllowFiltering= True
PTable.AllowCustomOrdering = True

PTable.DisplayFieldList = True
PTable.DisplayDesignTimeUI = True
PTable.DisplayToolbar = True
PTable.DisplayOfficeLogo = True
'PTable.EditMode = 1

PTable.Toolbar.Enabled = True
.TitleBar.Visible = True


OK, what am I doing wrong?

Thanks,
Chris

 

[Alvin Bruney]

Have you completely ruled out licensing issues? One quick way to tell is
typing something in the pivot table, if it doesn't let you, then you are in
view only mode. I'd suggest we rule that out before going further. What you
have posted so far does not eliminate a licensing issue by the way.