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?

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

Mike F
"James McDowell" <JamesMcDowell@discussions.microsoft.com> wrote in message
news:0C9B2200-9898-4F74-AED3-20732232A1AF@microsoft.com...
> 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?
>

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" <JamesMcDowell@discussions.microsoft.com> wrote in message
> news:0C9B2200-9898-4F74-AED3-20732232A1AF@microsoft.com...
> > 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?
> >
>
>
>

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" <JamesMcDowell@discussions.microsoft.com> wrote in message
> > news:0C9B2200-9898-4F74-AED3-20732232A1AF@microsoft.com...
> > > 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?
> > >
> >
> >
> >

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
> >
> >