Break connection to query?

[jpenn]

I have an Excel file that, when opened displays the following message:

"Cannot find '\\(file path)\ddexp132\excel\[Qe32.xla]Qe32'!$A$1, which has been assigned to run each time [filename.xls]SheetName is opened. Continuing could cause errors. Cancel opening [filename.xls]SheetName? Yes / No" (where file, path and sheet name are for the specific file I am using)

I think this was a connection to a query application (Q+E) we used to use. We don't need the query to run, and I'd like to eliminate this error message. I've tried looking in Edit - Links, Data - Import External Data to see if I could find an existing query there to remove. I found several Qe32.xla files on my C drive but don't know about deleting them.

Any suggestions? Thanks much!

 

[jpenn]

I found a solution - I went into the Insert - Name - Define menu and found a bunch of named ranges that were referring to external ranges. I deleted all the ranges and the error message no longer appears. That did it!