Pivot table Parameters

I know that you can't directly pass a parameter for a query through a pivot
table, but is there some way to by pass this? My problem is that I need to
create several graphs based on about 200 000 data points, comparing the
performance of several companies in a couple of areas on a monthly basis. I
have been given the task to automate it to a click of a button. I have so
far managed to achieve all the other functions through VBA, I am no pro,
however I have learned a fair amount from this site and some of the MVP sites.

Now what I have a pivot table linked to an Access database, to update it I
have to manually go into the query and change the criteria. However I was
wondering/hoping that I could reference it to the contents of a cell. I know
you can do this with normal queries, but i couldn't find out how to do it
with pivot tables, if it is even possible. If anyone has any ideas/ help I
would greatly appreciate it.

Thanks,

Anyways, I figured this out. If anyone sees this post and is curious, I'll
post my fix

Scott
"Scott" wrote:

> I know that you can't directly pass a parameter for a query through a pivot
> table, but is there some way to by pass this? My problem is that I need to
> create several graphs based on about 200 000 data points, comparing the
> performance of several companies in a couple of areas on a monthly basis. I
> have been given the task to automate it to a click of a button. I have so
> far managed to achieve all the other functions through VBA, I am no pro,
> however I have learned a fair amount from this site and some of the MVP sites.
>
> Now what I have a pivot table linked to an Access database, to update it I
> have to manually go into the query and change the criteria. However I was
> wondering/hoping that I could reference it to the contents of a cell. I know
> you can do this with normal queries, but i couldn't find out how to do it
> with pivot tables, if it is even possible. If anyone has any ideas/ help I
> would greatly appreciate it.
>
> Thanks,
>
>

Hi Scott. Please do post your fix! I would like to do the same thing.

Thanks,
KK