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
|