| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Data Area
Is there any way to overwrite the data in the data area, specifically what I
am doing is updating the Forecast for the BOY and would like to use the PT as a form that I would then feed back into my data source. For the previous Forecast update I copy/past/special/value then entered in the formulas for the subtotals. I can not re-use the form I previous created and I do not want to re-write all of the formulas to create the form for the 20 or so departments. -- CCO |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| text in data area on pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table: Custom formula in data area | Excel Discussion (Misc queries) | |||
| Data Area of Pivot Table and Pivot Charts | Charts and Charting in Excel | |||
| How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
| How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
Hybrid Mode
