VBA - how to stop when Saving a XLSM to XLSX with pivottables keeps external link to XLSM

[judgeh59]

That's a nasty title---

anyway - I have a XLSM that has 18 pivot sheets and summary that does a bunch of COUNTIFS. In the VBA I update my Raw Data Sheets and then do a REfresh all. All is wonderful. I have to save this file as an XLSX and then email a link to a bunch of people. Again, all is goodness and wonderfulness. BUT, when the XLSX file is opened the ENABLE CONTENT bar is there and when I check the data source for the pivot tables there are pointing back to the XLSM. Is there a way in the SAVEAS object to stop that. Yes, I'm working on uploading a file...here is the code SaveCustFile Code....thanks everybody

Please Login or Register  to view this content.

Added Data File --- it's a bit chopped up because I had to remove sensitive data....