Database Query Missing

  • Thread starter Thread starter Lingicer
  • Start date Start date
L

Lingicer

I have setup a database query in one worksheet in Excel 2003, Data => Import
External Data => New Database Query.
after I setup my query, I checked background refresh for every 300 minutes.
Somehow, the database query just disappeared for no reason. I right click
the data range that are supposed to have the database query defined. Nothing
happened. Even the "Refresh" button is grey. However, the "Refresh All"
button is still valid.
My PC has 1 GB memory, but I do have 20 excel files opened at the same time.

Please help, thanks a lot.
 
Somehow you deleted the query. Perhaps by deleting the rows/columns it went
to or the external name created.
 
Somehow you deleted the query. Perhaps by deleting the rows/columns it went
to or the external name created.
 
Don, thanks for your reply. I don't think deleting is the cause here because
I didn't do it. Appreciate your input though.
 
Don, thanks for your reply. I don't think deleting is the cause here because
I didn't do it. Appreciate your input though.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

External Data Refresh Issues 0
Excel 2003 randomly loosing database queries 1
Changing Database links? 3
External Data Refresh all just for one worksheet 3
Using MS Query in Excel 2007 4
Access Form Refresh 1
External data connection needs separate login for each query 1
Excel 2007 / MS Query - editing existing query to another sheet 0

Back
Top