Pivot Table Refresh Based On Inputs From Cell A2

Hi,

I have a Drop Down List in Cell A2 on Sheet named "Chart3"

I want a Pivot Table named "PivotTable3" to refresh automatically when input from Cell A2 changes

Any Help?

How about a Worksheet_Change event on the sheet? Right-click the sheet tab, click "View Code" and paste the following into the code window

Please Login or Register  to view this content.

cheers, teylyn

Originally Posted by teylyn

How about a Worksheet_Change event on the sheet? Right-click the sheet tab, click "View Code" and paste the following into the code window

Please Login or Register  to view this content.

cheers, teylyn

Hi,

Thank you for the reply.. Actually I cam up with the same code, however there is an issue I am facing..

I have some data from an SQL Server brought using Microsoft Query Using A2 as the Parameter.

Based on this I have created the Pivot table, when I change the Value from Cell A2, the new data from the DB Comes, but naturally does not refresh the Pivot Table Data, hence needed this code..

The problem is, when the Value from A2 changes, the Pivot Refreshes first and then the DB Data (Instead of the DB Data Refreshing 1st and then the Pivot Cache), hence reflecting the wrong data on the Pivot Table.

Can you guide me with that?

@ teylyn

Managed to get it working..

Thank you for the help!