EDITTING QUERIES RELATED TO QUERY TABLE

Y

Yuvraj

My excel templates are attached to cube.

But I see no way in which i can see the queries or modify the queries.
Please tell me a way where we can modify the queries related to a
query table.

When I go to the Data, Import wizard I see the edit query as
disabled.

I am not knowing how it is attached and how to edit the queries for an
existing excel template.

Please guide.

Regards,

Prince
 
J

joel

Yu have to select any cell where the result of the query is placed and then
go to Edit Query for it to be enabled. the SQL button we let you change the
query. Yo can't change the connection. If you need to change the connection
I will give you the steps. Basically you need to create a new qury and then
copy the SQL statements fro an old query to the new query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How are cube and queries related to excel templates coding 0
How to modify the Query Tables attached to a sheet in a excelworkbook 3
Is it possible to edit colours already saved as part of a custom theme? 0
How to modify and updte specific styles for specific paragraphs across the document 0
Need Help with Macro Security 1
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Changing margins on 2nd page of letterhead template 4
Import multiple Access Queries 0

Top