You can still do the copying and pasting values (By a sub-routine) and not
loose the formulas you want to keep, just set each section in ranges, some of
them wil paste values the others will paste formulas.
--
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!