How to modify the Query Tables attached to a sheet in a excelworkbook

[Yuvraj]

Hi All,

It will be great if anyone can tell me how to modify the query table
attached to a sheet in an excel template.

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

Please assist.

Regards,

Prince

 

[joel]

You can find the query in excel 2003 from the following menu

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

 

[Yuvraj]

You can find thequeryinexcel2003 from the following menu

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








- 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

 

[joel]

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.