Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating source data while in Pivot Table
Hi,
With a centralized shared file, several users would use several pivot tables to assess their plans, would dream of updating their source data right from the pivot table ... Has someone already faced (and fixed) this issue ? Thanks a lot Carim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating source data while in Pivot Table
Pivottables are summaries of data.
If you changed a data item within the pivottable, how would you guess which one of the (maybe) several detail rows that should get adjusted? If you were summing some numeric entry, and changed the value from 100 to 110, would you just add 10 to any detail row--or would you subtract 20 from one and add 30 to another??? I don't think this is "fixable". Carim wrote: Hi, With a centralized shared file, several users would use several pivot tables to assess their plans, would dream of updating their source data right from the pivot table ... Has someone already faced (and fixed) this issue ? Thanks a lot Carim -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating source data while in Pivot Table
Dave,
I understand what you are saying, and I totally agree with you. I am only referring to raw data (titles, labels, etc...)not to "processed" fields ... Cheers |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating source data while in Pivot Table
There's nothing built into excel that will do this for you.
I would just use Edit|Replace on the raw data. Carim wrote: Dave, I understand what you are saying, and I totally agree with you. I am only referring to raw data (titles, labels, etc...)not to "processed" fields ... Cheers -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating source data while in Pivot Table
Dave,
Just did a "Cells-Find" type of routine which sends user exactly back to the original data. Thanks again for your help Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table data source | Excel Worksheet Functions | |||
Pivot Table Source Data | Excel Discussion (Misc queries) | |||
updating pivot tables using dynamic data source | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
Error updating pivot table source data | Excel Programming |