activesheet.querytables(1).Delete

this would leave the data.

--
Regards,
Tom Ogilvy

"NYbills" wrote:

Would like a macro to remove the external data properties on a copied
worksheet.

The goal is to make the data static.

I have tried using the macro recorder but this does not record the
process/task.

Does anyone have any suggestions?