I am running the below Worksheet selection change..my pivot table is updating correctly, but something is going on with the refresh table part. I'm getting a runtime error that says: Cannot Open PivotTable Source File. The file that the pivot table is linked to is a share file not in my workbook. Any suggestions on how i might get around this?

Please Login or Register  to view this content.