When you run a recorded macro that formats a PivotTable, the PivotTable may be incorrectly formatted with the
Report 1 style.
Back to the top
This problem may occur if you formatted your PivotTable with the
PivotTable Classic AutoFormat when you recorded your macro.
In this case, the macro recorder adds an invalid constant (
xlClassicPivotTable) to the
Format method in your code. So, this constant gets evaluated to a value of zero, which is the same value as the
xlReport1 constant.
Back to the top
To work around this problem, modify the macro code that was generated by the macro recorder as follows:
| 1. | Start the Visual Basic Editor (press ALT+F11). |
| 2. | Replace the invalid constant xlClassicPivotTable with the correct constant xlPTClassic. |
| 3. | Close the Visual Basic Editor (press ALT+F11). |
Back to the top
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Back to the top