Run Time Error 1004 Pivot Table Name is not Valid

Are you certain that the pivot table is named exactly as the code says it is? Right click on the pivot table, left click on Table Options and verify the the name is PivotTable3.

Otherwise, you did not say what kind of error you are getting so post back and specify the error number and message for a more relevant suggestion.

Run Time Error 1004 Pivot Table Name is not Valid

Yes, the name of the pivot is exactly PivotTable3

Thanks.

There should be no logical reason for that. Usually 1004 refers to a protected sheet. In your case it's an invalid name.

I know you are sure, but try this anyway.

Select a cell in your pivot table.

Press Alt+F11 and then Ctrl+G and there in the Immediate Window type in or paste in
? activecell.PivotCell.Parent.name
and press the Enter key.

Now carefully copy that name from the Immediate Window and paste it into your macro and try the macro again.

Never mind, i found my problem. Another piece of my code changed the header to a different name, causing the pivot not to work. Thanks for your help.