Article ID: 236378 - Last Review: September 12, 2006 - Revision: 3.2 XL2000: Incorrect Classic PivotTable Format Constant Recorded in MacroThis article was previously published under Q236378 SYMPTOMS
When you run a recorded macro that formats a PivotTable, the PivotTable may be incorrectly formatted with the Report 1 style.
CAUSE
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. WORKAROUND
To work around this problem, modify the macro code that was generated by the macro recorder as follows:
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
| Article Translations
|
Back to the top
