Pivot tables with external data source


M

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
 
Ad

Advertisements

M

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
 
Ad

Advertisements

G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top