If you see this error, try renaming the sheet that contains the PivotTable so that it has no spaces or & in the name. If the associated data sheet is also visible in the workbook (usually prefixed 'ACCDIMAA_DATA_...'), also remove spaces and & from that sheet. The data sheet name should match the PivotTable sheet name. For example, if your PivotTable sheet is called 'MyAccountsPivot', the data sheet should be called 'ACCDIMAA_DATA_MyAccountsPivot'. You could also try replacing spaces and & with an underscore.
