Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. "Yuvraj" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I need help with a table formula/mass editting | New Users to Excel | |||
Vookup related query | Excel Worksheet Functions | |||
How are cube and queries related to excel templates coding | Excel Programming | |||
Macro Related Query | Excel Programming | |||
Problem with CPU Usage 100% related to stored external queries | Excel Programming |