The property sheet will tell you the worksheets where the queries are listed.
You then have to go to the worksheet to locate the query. Once the
worksheet is selected then you have to go to the names (Insert - Names -
Define) to find the range where the query is located. Then select a cell in
the defined name and go to Data - Import External Data - Edit Query. This is
stupid but it is the only way.

"Yuvraj" wrote:

On Apr 8, 7:06 pm, joel wrote:
You can find thequeryinexcel2003 from the following menu

Files - Property - custom.. they will be in the properties window.



"Yuvraj" wrote:
Hi All,

It will be great if anyone can tell me how to modify thequerytable
attached to a sheet in anexceltemplate.

At present I am haveing a sheet which has aquerytable. I do not know
how to modify it as i cannot see it any where.

Please assist.

Regards,

Prince- Hide quoted text -

- Show quoted text -

Thank you for the answer but I cannot see such options where I can see
the queries. Please provide a detailed step as In property window I do
not see the query which can be opened, I can only see some names but
not the queries which I want to edit.

Regards