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?