Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table | Excel Discussion (Misc queries) | |||
Can I set a filter on the source data for a pivot table | Excel Discussion (Misc queries) | |||
Graph from a PIVOT table: update not working. Please Help! | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |