The code below saves a worksheet in another workbook so i can email it without data connections and without the pivot table active (the pivot table is connected to the data source). The problem in the new workbook is that the connection name is still showing in the connections properties window (and when you attempt to refresh you recieve an errror, so it is deleted but for some reason it still shows the connection) and the pivot table is still active in the new workbook.

I want to delete the data connection because it deletes the ability to do anything with the pivot table that is connected to the datasource. Thank you.

Please Login or Register  to view this content.