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?