Refresh Table method of PivotTable class failed - on macro run, not always on macro step

I am developing a macro to locate pivot table errors. It lists all pivot tables in a workbook with associated error messages. When I run it, each pivot table fails with the message "RefreshTable method of PivotTable class failed" unless another error had occurred with its own message. However, if I step through the macro, this message does not appear, and the refreshes complete OK.

What's causing the message?

Hi Carim

If you can avoid pivot table errors when you have hundred of PTs you're a marvel.

Another is Debra, to whom you refer. I have used her code to help find pivot tables in error, extending it to pin down the specific table rather than just identifying others in the same rows or columns for overlap problems. Still de-bugging it, but its looking good.

Still haven't solved "RefreshTable method of PivotTable class failed".

Peter

Hi Carim

Optimnising caches is the very thing that makes it had to locate pivot table errors, as an error in any pivot table sharing a cache affects all the others. My solution is to shift all pivot tables to separate caches, locate and fix any errors, then recombine them to optimise the caches.

Peter