VBA code:

Myworksheet.QueryTables("my_query").EnableRefresh = False

should do the trick

I would suggest creating a copy of the workbook first, else *you* wont
be able to refresh the table as well.

DM Unseen