|
Posted to microsoft.public.excel.misc
|
|
|
Relative Values in Pivot Table
--
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
|