Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to refresh a Scenario PivotTable Report?
Hi,
I am trying to solve the following issue: My excel workbook includes two kind of input values: 1) Assumptions (I am using a Scenario PivotTable Report to track the effect of different assumption sets on the "result cell"); 2) Background data (Its values also affect the "result cell" and they are changing time to time. I can not create scenarios for every background data cell, as there are too many of them). Every time background data change (quite often), I must rebuild Scenario PivotTable Report, as it does not take into account the updated values. Is there any quick way to refresh a Scenario PivotTable Report? Thanks in advance, Gerry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refresh and PivotTable with Analysis Services | Excel Worksheet Functions | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Refresh scenario information in a pivot table | Excel Discussion (Misc queries) | |||
Refresh Pivottable last 4 weeks data from today | Excel Worksheet Functions | |||
why report manager ignores the range set in the scenario | Excel Discussion (Misc queries) |