Refreshing Pivot Tables/Charts for Dashboard type report in VBA

[Orada]

Hi All,

I have a workbook which I periodically update from 3 other files. I have built pivot tables and charts on a single sheet of that workbook based on this imported data and use this in a report of tables and charts, dashboard style.

Simply I need the charts and tables on the report worksheet to be dynamic and updated after each import of new data.

Q1, When I update the sheet with fresh raw data do I just need to refresh the PivotCache for each set of data?

Q2, If so does the naming format for PivotCache(s) follow the style PivotCache1, PivotCache2 etc?

Thanks in advance, working with VBA is still fairly new to me and working with Pivot Tables and Charts is another fresh learning goal.

[protonLeah]

title updated

[Orada]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Thank you for your feedback, my mistake