I don't know how to be more specific than to say again:

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


I am assuming that you are using Excel 2002 or later (it always helps
if you say which version) and that the data was brought in from Access
by Data / Import External Data / New database query.

If this is not the case then you will have to help me by giving me more
information about what you did.

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