Here are some problems that our users have asked and received explanations on
Using VBA to update pivot table filter from multiple values in a list
Solved by I. Y. in 22 mins
I have VBA code that manages to create a new pivot cache for a pivot table (the data is in one worksheet and the pivot table is in another worksheet - but same workbook) - however, the refreshing of data is not successful and I'm stuck as to why because the other pivot tables are working fine and update with VBA code... I've tried PivotCache.Refresh and I've tried PivotTables.RefreshTable options; I'm stuck. When I do this manually - it updates, just not in code...
Solved by K. H. in 25 mins
I'm trying to write VBA code that filters a Pivot Table based on a single cell value, but it's erroring out.
Solved by F. A. in 30 mins
I'm trying to total the values in a pivot table. Essentially i want another value in the pivot table which displays the sum of the other pivot table columns.