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.
--
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
-----------------------------------------------------------------------
"James D. Sheehan" wrote in message
...
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.
--
James D. Sheehan

--
James D. Sheehan


"Earl Kiosterud" wrote:

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
-----------------------------------------------------------------------
"James D. Sheehan" wrote in message
...
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.
--
James D. Sheehan

Thank you Eric...a little above my head. But super thanks. Jim