Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Problem with MS Query - can't edit query
Is there a known issue using MS Query with Excel? More often than not, after creating an External Query and editing it with MS Query, I am suddenly unable to Edit Query... from the Data menu. When I do select it, Excel appears to think for a minute with a message: "Waiting for data to be returned from MS Query...", but then nothing happens. Is there another way to get to the SQL or MS Query? -- jarems |
#2
|
|||
|
|||
Problem with MS Query - can't edit query
I too am having the same problem with Excel 97 and Excel 2000 on different
PCs. The same programs run OK on two other machines where I have never updated MS Office, so I think the problem lies here. -- Richard E "jarems" wrote: Is there a known issue using MS Query with Excel? More often than not, after creating an External Query and editing it with MS Query, I am suddenly unable to Edit Query... from the Data menu. When I do select it, Excel appears to think for a minute with a message: "Waiting for data to be returned from MS Query...", but then nothing happens. Is there another way to get to the SQL or MS Query? -- jarems |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with MS Query - can't edit query
Richard E Wrote: I too am having the same problem with Excel 97 and Excel 2000 on different PCs. The same programs run OK on two other machines where I have never updated MS Office, so I think the problem lies here. -- Richard E "jarems" wrote: Is there a known issue using MS Query with Excel? More often than not, after creating an External Query and editing it with MS Query, I am suddenly unable to Edit Query... from the Data menu. When I do select it, Excel appears to think for a minute with a message: "Waiting for data to be returned from MS Query...", but then nothing happens. Is there another way to get to the SQL or MS Query? -- jarems Still not resolved this problem from last October. Anyone have any advice? -- Richard E ------------------------------------------------------------------------ Richard E's Profile: http://www.excelforum.com/member.php...o&userid=28054 View this thread: http://www.excelforum.com/showthread...hreadid=472659 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query not installed for New Database Query | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
User Defined Variables in MS query cause a problem to import data | Excel Discussion (Misc queries) | |||
Problem Code: Retrieving Stored Access 03 Query | Excel Discussion (Misc queries) | |||
Problem with Query | Links and Linking in Excel |