I have an excel spreadsheet with several pivottables built on an Analysis Services cube. I am after help to set up a suto-refresh that updates pivot tables when a cell changes. How can I reset a pivot table to show all items (select all avaiable checkboxes) like in the drop down menu via vba?Now all pivots use the same filter and I would like to write a vba macro to set the field of a pivot to the correct value.
Bookmarks