Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to create Macro that can build a Scenario PivotTable Report?
Hi,
As there is no way to refresh a Scenario Pivot Report, I must rebuild it each time my background data changes. To save time, I have tried creating macro command that would build a new Scenario Pivot Report for me. I have recorded the macro by manually creating and formating the Report. In result, the macro command managed to hide fields i did not need, but it failed to assign new data to pivot fields (for example, to move certain data from the column field to the row field). How could I fix this? Thanks in advance, Gerry |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to refresh a Scenario PivotTable Report? | Excel Discussion (Misc queries) | |||
How to create an excel Pivottable-report from a dos command | Excel Programming | |||
why report manager ignores the range set in the scenario | Excel Discussion (Misc queries) | |||
How does one get the PivotTable report info that feeds another PivotTable report? | Excel Programming | |||
Creating a PivotTable Report from an Another PivotTable Report | Excel Programming |