Pivots and external links

J

John

I have a pivot table that's currently externally linked to a database
table that has over 300k records. Is there anyway to filter the
database records before loading the pivot table? Otherwise, the pivot
loads/refreshes with all 300k records and takes too long.

Thanks for any tips!
 
M

mk

I have a pivot table that's currently externally linked to a database
table that has over 300k records. Is there anyway to filter the
database records before loading the pivot table? Otherwise, the pivot
loads/refreshes with all 300k records and takes too long.

Yes, you can add filters in MSQuery.
When you created your pivot table with external datasource, you must have
a window titled 'Query Wizard - Filter Data' - it allows to add filters. You
can also add
filters directly in MSQuery.

If you want to edit you data source now, right click PT, choose PT Wizard,
press Back button
and press Get Data button, then follow wizard steps. The second window is
filtering.
 
J

John

Thanks Marcin...

Is there any way to maybe code an external link and use cell values as
parameters, instead of requiring a user to back-track through the
wizards? Or maybe the wizard/MS Query can utilize Excel cell values as
parameters for the query?
 

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