Hi Ron - I had tried that previously, and editing the SQL was no
problem. (In fact I could open the spreadsheet with no file at the
original location, it would just tell me it couldn't find it, then I'd
"cancel" instead of trying to locate it [locating it didnt solve
anythign either].)

The problem is Excel is somehow, somewhere, storing the old filename.
When I go into the SQL, I can edit the FROM statement, and when I save
the workbook and open again, the SQL is fine (points to the new
filename) but Excel still looks for the old filename.

In the meantime I just deleted all the queries and made new ones, and
it works. However there must be someplace Excel is storing the old
filename. Forwhatever reason, M$ has not allowed a user to get to it
easily.

Thanks for the reply.Dave