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

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

How to modify the Query Tables attached to a sheet in a excel work
 

You can find the query in excel 2003 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 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

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

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

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

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