Rather than sending the original file, send a version where you have copied
and pasted values only.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"erick-flores" wrote:

Hello all

I have a Workbook that has 4 pivot tables. Each PT has its own ODBC
connection.

I have a button that sends the workbook via email, but I want to
remove/delete all the connections from the PivotTables because I dont
want the email receiver to be able to refresh the data.

Any ideas? I am using Excel 2003.

Thanks in advance!