Hello everyone,

I hoping to get some help with a code error that I get only sometimes when running the macro. While at other times the code works great. A little frustrating...

The error:
Run-time error '1004':

The PivotTable report was saved without the underlying data. Use the Refresh Data command to update the report.
The error occurs at this line: 
Please Login or Register  to view this content.
Please see the red, bolded, underlined, and italicized part of the code below. (Note this code is slightly modified from Jerry Sullivan's code.)

The purpose of the macro:
Change the data source of the pivot tables in a workbook, while keeping the same slicer connections.




Code:
Please Login or Register  to view this content.
Any suggestions?

Thanks!

Geoff.