AndyDevine1
Board Regular
- Joined
- Jun 1, 2006
- Messages
- 172
hi there
There is code to update pivot tables in a workbook I've inherited
Running this is causing an error as the tables cannot locate the source data
I've gone through the many pivot tables and re-pointed them to the correct data source
When I re-run the code it is still telling me there are some pivot tables where the data source cannot be found.
I've no hidden worksheets
Is there a way I can locate the remaining pivot tables in order to fix the problem?
Many thanks
There is code to update pivot tables in a workbook I've inherited
Running this is causing an error as the tables cannot locate the source data
I've gone through the many pivot tables and re-pointed them to the correct data source
When I re-run the code it is still telling me there are some pivot tables where the data source cannot be found.
I've no hidden worksheets
Is there a way I can locate the remaining pivot tables in order to fix the problem?
Many thanks