| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.links
|
|||
|
|||
External Query Definition Disappears
I use many external database queries in my worksheets. To refresh results, I
simply right click in the data and select Refresh. Sometimes, however, after the refresh, I right click again and find that the query definition has disappeared, meaning the worksheet thinks I've returned text only and there is no option to refresh any longer. I keep archives of my queries so I can copy/paste back my original query. But this is a major pain. I can't find anything in the Microsoft knowledgebase on this. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to do Edit Query from Import External Data. | Excel Discussion (Misc queries) | |||
| Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
| How do i enable the Query Parameter menu option on the External D. | Excel Discussion (Misc queries) | |||
| Query of External Data | Excel Discussion (Misc queries) | |||
| Pivot Tables referring to external data query | Excel Discussion (Misc queries) | |||
Threaded Mode
