I am new to Pivot Tables, but it appears that the pivot table data is static. When I create the Pivot Table with a Sum of Amount as data, if I change the input data on worksheet 2, the Pivot Table data remains as it was when I created it.
I have assumed that this is a function of a Pivot Table, so I created a macro that will refresh the Pivot Table. (Now that I have searched this forum I see there is a much easier way of doing the refresh in the macro than the method I am using......isn't there always...lol)
What I really want to do, is have the refresh occur automatically every time the Pivot Table sheet becomes Active. That way there is no chance of someone changing data in worksheet2 and then looking at the old Pivot Table. As soon as they come back to the Pivot Table sheet the refresh would occur.
I assume there is an event handler for Active Worksheet, but I'm not having any luck in locating it. I'm also assuming I could call my refresh Pivot Table macro upon this event.
Am I close ?
I have assumed that this is a function of a Pivot Table, so I created a macro that will refresh the Pivot Table. (Now that I have searched this forum I see there is a much easier way of doing the refresh in the macro than the method I am using......isn't there always...lol)
What I really want to do, is have the refresh occur automatically every time the Pivot Table sheet becomes Active. That way there is no chance of someone changing data in worksheet2 and then looking at the old Pivot Table. As soon as they come back to the Pivot Table sheet the refresh would occur.
I assume there is an event handler for Active Worksheet, but I'm not having any luck in locating it. I'm also assuming I could call my refresh Pivot Table macro upon this event.
Am I close ?