Pivot tables with external data source

[Mette]

Hi!
I use a lot of pivottables with connetions to external data sources.
Sometimes I need to modify the queries, and I do this by using the
pivottable wizard, and press "get data" from step 2 in the wizard. I then
get access to MS Query and can edit whatever I need to. But from time to
time I only get the message "No data fields have been retrieved", and
nothing happens. Usually I can get access by refreashing the table and try
again, but this time I've even copied the table into another workbook
without success.

Does anyone have a solution for my problem? How do I get access to my query?

Thanks, Mette

 

[Guest]

See if this gets you any closer to debugging your query....

http://www.contextures.com/xlPivotPlay01.html

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[Mette]

Hi Ron,

your plugin is absolutely amazing and I can now modify my query, thanks!

Btw, I sometimes get the same problem when I try to edit external data
outside of pivottables too, but never to the extent that a refresh didnt fix
it. If you have some solution for this too I would be eternally grateful =)

Regards, Mette

 

[Guest]

Thanks so much for the feedback....I'm glad Pivot Play could help.

(I've been toying with the idea of building one for query tables.)
***********
Regards,
Ron

XL2002, WinXP