Error message when you play a recorded macro to create a PivotTable in a new worksheet in Excel 2007

To resolve this problem, follow these steps: In the Microsoft Visual Basic Editor (VBE), locate the code for the recorded macro. Empty the value of the TableDestination variable as in the following example. TableDestination="" Remove the following lines f

support.microsoft.com