Hi, using excel 2010 and trying to create macro package for fast save. Have an external file with multiple pivot tables that I'm using and copying certain pages out of the old workbook to create a new workbook and breaking links to the old. I specify the new source as table 1 in the new workbook, but after saving the new workbook it's coming up with "The PivotTable report was saved without the underlying data". I would like for the new workbook to be saved with the new specified data active and not have refresh the Pivots on each tab. Below is a portion of the code i'm using.
My thought is the astrlinks should be reactivated before saving but I'm not sure how.
Bookmarks