The PivotTable field name is not valid '-2147024809 (80070057)'

The following error message Just started occurring in my VBA script:

Run-time error '-2147024809 (80070057)'

The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of the PivotTable field, you must type a new name for the field.

The line of code which abends:

Please Login or Register  to view this content.

The source data has not changed. When recording the macro, the syntax is the same. When manually selecting PivotTable Analyze, Change Data Source, the process works FINE.

Any help will be truly appreciated. Thank you!

Can you please attach your file and tell us what steps to take to reproduce the error? The problem may not be in the code but in the pivot table itself. I am puzzled by the error message because it does not include a PivotTable name field. Are you certain that's the right line of code?

You didn't attach a file.

How is PivotRange declared (as Range or as String?) and set?

To attach a file, use the Paper Clip icon and follow instructions, or use this method:

1. Under the text box where you type your reply click the Go Advanced button.
2. On the next screen scroll down and under the Attachments section click the Manage Attachments link, which will show a pop-up window.
3. Click the Choose File button to select a file to attached.
4. Click the Upload button to upload the file.
5. Then click the Close This Window button. Your file is now attached to your post.

The problem is that you should have single quotes around the sheet name as it has spaces in it, and a recent update is much less forgiving of that than previously:

Please Login or Register  to view this content.

Glad we could help.