update the underlying data source of a pivot table
 

is there any functionality to update or change the underlying data set using
the pivot table itself. i.e. i have pivot table that consolidates a large
budget, and want to update certain items in the pivot table display... can
these changes be pushed back to the data set.

update the underlying data source of a pivot table
 

From a trawl through google archives,
perhaps this J-Walk tip would be relevant:
http://j-walk.com/ss/excel/usertips/tip068.htm
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Ben Hall" <Ben wrote in message
...
is there any functionality to update or change the underlying data set
using
the pivot table itself. i.e. i have pivot table that consolidates a large
budget, and want to update certain items in the pivot table display... can
these changes be pushed back to the data set.