Context Menu on Pivot Table does not show Edit MS Query

[bajo71]

Hello,

I am using Excel 2007 and cannot find the 'Edit MS Query' option in the context menu of a pivot table. How can I access this through the GUI?

With VBA I see it clearly in the Immediate Window...

?ActiveSheet.PivotTables(1).PivotCache.CommandText
SELECT tblFinReporting.Type
FROM `R:\Accounting\20 Envoy\`.tblFinReporting tblFinReporting

but not in GUI...

Thanks

 

[SkipVought]

Hi,

alt+DP

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bajo71]

That only brings up Pivot Table Wizard. I found it under Data-Properties-Definition. Was wondering if I could add the Edit Query command to the context window.

 

[SkipVought]

If this for an existing PivotTable?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

How about right-click in the PT, hit the BACK button and have at the query editor.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

How about right-click in the PT, select PivotTable Wizard, hit the BACK button and have at the query editor.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bajo71]

The only associated command is Pivot Table Options when I right click within the PT

 

[SkipVought]

What happens if you Right-Click in the PT and then hit W?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[bajo71]

Not a thing.

 

[SkipVought]

Try posting your question in Forum68, sans VBA code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}