ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Embedded queries... (https://www.excelbanter.com/excel-programming/342304-embedded-queries.html)

James McDowell[_2_]

Embedded queries...
 
How can I view an embedded query?

I have inherited a spreadsheet and I need to validate the data being pulled.
How can I do this if it is embedded within the worksheet?


Mike Fogleman

Embedded queries...
 
Right-click within the query output range on the sheet and select 'Edit
Query'.

Mike F
"James McDowell" wrote in message
...
How can I view an embedded query?

I have inherited a spreadsheet and I need to validate the data being
pulled.
How can I do this if it is embedded within the worksheet?




TinaInSC

Embedded queries...
 
Hi Mike,
I'm on Windows 2000 and using Office 2000. For some reason, the Edit Query
appears, but when I click on it, nothing happens? I don't get my query to
edit and I don't get any messages? Any clues as to what might be going on
here?
Thanks,
--
Tina


"Mike Fogleman" wrote:

Right-click within the query output range on the sheet and select 'Edit
Query'.

Mike F
"James McDowell" wrote in message
...
How can I view an embedded query?

I have inherited a spreadsheet and I need to validate the data being
pulled.
How can I do this if it is embedded within the worksheet?





Dave Benzenhafer

Embedded queries...
 
I have the same problem. has anybody figured this one out yet?

"TinaInSC" wrote:

Hi Mike,
I'm on Windows 2000 and using Office 2000. For some reason, the Edit Query
appears, but when I click on it, nothing happens? I don't get my query to
edit and I don't get any messages? Any clues as to what might be going on
here?
Thanks,
--
Tina


"Mike Fogleman" wrote:

Right-click within the query output range on the sheet and select 'Edit
Query'.

Mike F
"James McDowell" wrote in message
...
How can I view an embedded query?

I have inherited a spreadsheet and I need to validate the data being
pulled.
How can I do this if it is embedded within the worksheet?





evapoo

Embeddpsed queries...
 
I had this happen recently. It turned out the worksheet was protected. It
would not show there was a query there that I knew existed.

Hope this helps.

Kristen

"Dave Benzenhafer" wrote:

I have the same problem. has anybody figured this one out yet?

"TinaInSC" wrote:

Hi Mike,
I'm on Windows 2000 and using Office 2000. For some reason, the Edit Query
appears, but when I click on it, nothing happens? I don't get my query to
edit and I don't get any messages? Any clues as to what might be going on
here?
Thanks,
--
Tina





All times are GMT +1. The time now is 08:24 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com