RefreshTable method of PivotTable class failed

[Aland2929]

This is the code I am using:

Please Login or Register  to view this content.

I receive the following error message, which I don't understand: RefreshTable method of PivotTable class failed
I would appreciate any help.
Thanks in advance

[Macdave_19]

Hi Buddy,


Try Specifying the Sheet name if its only 1 sheet that is being refreshed:

Please Login or Register  to view this content.

If You want to Refresh Certain sheets then use this:

Please Login or Register  to view this content.

[Aland2929]

Thanks very much for your reply. I found the problem. I renamed the file with a different name. I had to go to Options and Change Data Source and then the above code worked. Once again, thanks for your response.

[rmat3]

I am unable to find fix for this problem. I tried your approaches.

[blakec4]

I had the same problem and solved it. Here was my problem...
I had a dynamic named range for the data source. The named range counted the number of columns COUNTA(ErrorMessages!$1:$1) in my data (and number of records COUNTA(ErrorMessages!$A:$A) in the list). I happened to add some text to the very first row outside the list range and the refresh tried to add an extra column that did not have a column header.

The dynamic named range (Raw_Error_Data) was:
=OFFSET(ErrorMessages!$A$1,0,0,COUNTA(ErrorMessages!$A:$A),COUNTA(ErrorMessages!$1:$1))

I removed the spurious text in the first row and everything worked.