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!
 
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?
 
Top