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?
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?
Cheers!
Deep Dave
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
cheers, teylynPlease Login or Register to view this content.
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!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks