View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max
 
Posts: n/a
Default 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.