Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9,101
Default EDITTING QUERIES RELATED TO QUERY TABLE

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need help with a table formula/mass editting urlocaljeweler New Users to Excel 2 November 18th 09 07:29 PM
Vookup related query Manish Gurve Excel Worksheet Functions 3 August 10th 09 02:53 PM
How are cube and queries related to excel templates coding Yuvraj Excel Programming 0 April 8th 09 10:26 AM
Macro Related Query SRV....Frenzy Excel Programming 0 April 4th 07 04:49 PM
Problem with CPU Usage 100% related to stored external queries David Excel Programming 0 February 4th 06 01:03 AM


All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"