I have a pivot table connected to an Access query. When i send the workbook with the pivot tables via email i want to delete the data connection and the use of the pivot table. I know i can remove the data connection in the Data Connections properties with the Remove button and then lock down each sheet to diable pivot table use.

For some reason when i delete data connections and save the workbook i am emailing, the data connection shows back up when i open the workbook, even though i cannot refresh the data source, and it gives the user the ability to use the pivot table.

Why does the data connection, and the pivot table, keep showing up after i deleted the connection?