View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lingicer Lingicer is offline
external usenet poster
 
Posts: 2
Default Database Query Missing

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.