Get instant live expert help on I need help with pivot table in vba
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
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.
Solved by V. D. in 18 mins
=IFERROR(VLOOKUPSTR(D26,'Pivot Table 2'!B:Q,16,'Pivot Table 2'!B:W,22,'Pivot Table 2'!B:AD,29,'Pivot Table 2'!B:AK,36,'Pivot Table 2'!B:AR,43,0),0)
Solved by I. F. in 30 mins