RefreshAll & ShowDetail

I have the following very small macro in several workbooks.

Please Login or Register  to view this content.

It's purpose is simply to refresh a pivot table, and then open it up. However, in this workbook it's giving me an "unable to set the showdetail property of the range class" error. Each line works perfectly by itself, but when I put them both together it keeps erroring out. Anyone have any ideas?

Hi there,

The first line will apply to the entire workbook, but the second line will apply to Cell C14 on whichever worksheet happens to be active when the code is executed. An error will occur if the ShowDetail property isn't appropriate to Cell 14 on the active worksheet.

In general you should always fully qualify the ranges you are using, e.g.

Please Login or Register  to view this content.

Hope this helps,

Regards,

Greg M

I had tried that already, no luck. This workbook only has the one sheet, so the wrong sheet being active isn't a concern.

I did notice that if I debug the error, and immediately continue running the macro without doing anything else, it runs without issue.