Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database Query Missing
Somehow you deleted the query. Perhaps by deleting the rows/columns it went
to or the external name created. -- Don Guillett Microsoft MVP Excel SalesAid Software "Lingicer" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Database Query Missing
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 Guillett" wrote: Somehow you deleted the query. Perhaps by deleting the rows/columns it went to or the external name created. -- Don Guillett Microsoft MVP Excel SalesAid Software "Lingicer" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
database query not showing foxpro database How I import data | New Users to Excel | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |