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.