Could you be more specific as to how I accomplish this? Thank you.

"Bill Manville" wrote in message
...
You probably want to make the query a dead copy of the data rather than
saving the query definition.

Put the cursor in the query output table and Data / Import External
Data / Data Range Properties ... uncheck Save Query Definition.


Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup