Pivot table does not refresh automatically.

Hello,

I have a pivot table and I have a macro to refresh that pivot table. When I add a new line with information to the source sheet, the pivot table does not refresh automatically after running the macro. However if I manually refresh the pivot table using <right click> + refresh, the pivot table refreshes with new information.

Has anyone faced such an issue.

Where is the macro? Is in the module? If it is, probably try to move it to source data sheet.

Would it really matter if the macro is in module or in the source data sheet. One thing I have noticed is, even though the source data is same for multiple pivots, I need to manually refresh each pivot. I do not think this should be a case normally.

Yes, it would. You want it to refresh authomatically, so it has to be an event triggered event, otherwise you run it as a normal module. The event is a change you make to your source data. If you wish to refresh more than one pivot source, you need to put your code in to "This workbook". Try this code. Put it in the sheet name- source data. The pivot will refresh automatically when ever you make any change in your source data.

Please Login or Register  to view this content.

Please adjust the code as per your data, or change the name of your table to ("PivotTable1").

Thanks. it worked.