Hi,
I am trying to refresh pivot tables in my workbook but each time I get the following error message:
Untitled.png
How do I identify which of the many pivot tables that is and where it is in my workbook?
Thanks
Hi,
I am trying to refresh pivot tables in my workbook but each time I get the following error message:
Untitled.png
How do I identify which of the many pivot tables that is and where it is in my workbook?
Thanks
Hi Bnewsom & welcome to the forum
You can run the below code & it will show you the sheet name & address of all PivotTable4 in your workbook in the VBE immediate window
Please Login or Register to view this content.
If I was able to help, you can thank me by clicking the * Add Reputation under my user name
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks