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
|