ActiveSheet.QueryTables(1).Delete

after you refresh the data.

--
Regards,
Tom Ogilvy

<M.Streeks wrote in message
...
I have an excel template which pulls some data from my SQL server when
opened. I need to set it so that it only pulls up the data when first
opened
from a template, but not after being saved as an xls file.

Any ideas?