Relative Values in Pivot Table

[James D. Sheehan]

Is there a way to develop a pivot table from a data file and then have the
data change and automatically change the pivot table?? I reference the
resluts in the pivot table and want the values to change. Thanks.

 

[Earl Kiosterud]

James,

You could just manually refresh the pivot table (right-click - Refresh data). You can use an
event-fired macro to do the refresh. It could be the worksheet_change event on the data
that runs it. Or you can use the Worksheet_Activate event to only refresh it when the user
selects the sheet the pivot table's in.

 

[James D. Sheehan]

--
James D. Sheehan

James,

You could just manually refresh the pivot table (right-click - Refresh data). You can use an
event-fired macro to do the refresh. It could be the worksheet_change event on the data
that runs it. Or you can use the Worksheet_Activate event to only refresh it when the user
selects the sheet the pivot table's in.
--
Regards from Virginia Beach,

Earl Kiosterud
www.smokeylake.com