Pivot table not updating when using data validation

**aimone111** · 07-21-2015, 06:44 AM

Hi,
I have some code that is trying to update my pivot table, but when I select a dropdown i have to come off it and click the cell to update the data. Please could anyone help? I have searched but cant find anything that matches what I am trying to do. All i want it for it to update when i select one of the dropdowns. The code is below.

Thank you

Please Login or Register  to view this content.

**joris moerings** · 07-21-2015, 08:55 AM

Hi,

When posting a question next time try to comply to forum rules. Reading code without code tags is sometimes undoable.
Having said that, try this code. Please remember to change the fieldname to apply the filter to!

Please Login or Register  to view this content.

**aimone111** · 07-21-2015, 09:10 AM

Thank you Joris, your a star, that worked perfect, I will make sure I do that from now on with code tags.

Thanks
Dustin

**joris moerings** · 07-21-2015, 09:56 AM

Hi Dustin,

Please mark issue as solved if you're happy with the provided solution.

Pivot table not updating when using data validation

LinkBack

Thread Tools

Rate This Thread

Display

Pivot table not updating when using data validation

Re: Pivot table not updating when using data validation

Re: Pivot table not updating when using data validation

Re: Pivot table not updating when using data validation

Thread Information

Users Browsing this Thread

Similar Threads

Problems updating Pivot Table with new data

Help with Pivot table data updating issue

Updating Two Pivot Filters based on Two Data Validation Cell Text

Pivot Table data not updating when Report Filter changes

updating a pivot table with current year's data

[SOLVED] Updating Pivot Table Column Date Data

Updating source data while in Pivot Table

Bookmarks

Bookmarks

Posting Permissions