|
Query Wizard Cannot Be Used To Edit This Query
I am trying to edit a query in an Excel worksheet to change the name of the
source file but keep getting the message, "Query wizard cannot be used to edit this query". The worksheet is not protected. Does anyone have a suggestion? Thanks in advance. |
Query Wizard Cannot Be Used To Edit This Query
If you click OK, Microsoft Query should open, and you can edit the
source file name in the SQL string. Carl wrote: I am trying to edit a query in an Excel worksheet to change the name of the source file but keep getting the message, "Query wizard cannot be used to edit this query". The worksheet is not protected. Does anyone have a suggestion? Thanks in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Query Wizard Cannot Be Used To Edit This Query
Thanks, Debra, I really appreciate your help but nothing happens when I click
OK. I tried to get Microsoft Query to open by selecting €śData€ť then €śGet External Data€ť, then €śEdit Query€ť which gave me the message, "Query wizard cannot be used to edit this query". I also tried selecting "Data", then "! Refresh Data", which also gave me the same message. Do you have any other suggestions? Thanks in advance. "Debra Dalgleish" wrote: If you click OK, Microsoft Query should open, and you can edit the source file name in the SQL string. Carl wrote: I am trying to edit a query in an Excel worksheet to change the name of the source file but keep getting the message, "Query wizard cannot be used to edit this query". The worksheet is not protected. Does anyone have a suggestion? Thanks in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Query Wizard Cannot Be Used To Edit This Query
Do you know what the current source file is?
Carl wrote: Thanks, Debra, I really appreciate your help but nothing happens when I click OK. I tried to get Microsoft Query to open by selecting €śData€ť then €śGet External Data€ť, then €śEdit Query€ť which gave me the message, "Query wizard cannot be used to edit this query". I also tried selecting "Data", then "! Refresh Data", which also gave me the same message. Do you have any other suggestions? Thanks in advance. "Debra Dalgleish" wrote: If you click OK, Microsoft Query should open, and you can edit the source file name in the SQL string. Carl wrote: I am trying to edit a query in an Excel worksheet to change the name of the source file but keep getting the message, "Query wizard cannot be used to edit this query". The worksheet is not protected. Does anyone have a suggestion? Thanks in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Query Wizard Cannot Be Used To Edit This Query
No, unfortunately. That is why I am trying to edit it...to find the old name
and change it to the new name. Someone else set up the original query but then the source file changed after they left the company. Thanks again! "Debra Dalgleish" wrote: Do you know what the current source file is? Carl wrote: Thanks, Debra, I really appreciate your help but nothing happens when I click OK. I tried to get Microsoft Query to open by selecting €śData€ť then €śGet External Data€ť, then €śEdit Query€ť which gave me the message, "Query wizard cannot be used to edit this query". I also tried selecting "Data", then "! Refresh Data", which also gave me the same message. Do you have any other suggestions? Thanks in advance. "Debra Dalgleish" wrote: If you click OK, Microsoft Query should open, and you can edit the source file name in the SQL string. Carl wrote: I am trying to edit a query in an Excel worksheet to change the name of the source file but keep getting the message, "Query wizard cannot be used to edit this query". The worksheet is not protected. Does anyone have a suggestion? Thanks in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Query Wizard Cannot Be Used To Edit This Query
You could try programming to write the connection string to a worksheet.
Then, edit the string, and reset the connection. For example, with the query on sheet1: Sub GetQueryInfo() Worksheets("Sheet2").Range("B2").Value _ = Worksheets("Sheet1").QueryTables(1).Connection End Sub Sub SetQueryInfo() Worksheets("Sheet1").QueryTables(1).Connection _ = Worksheets("Sheet2").Range("B2").Value End Sub Carl wrote: No, unfortunately. That is why I am trying to edit it...to find the old name and change it to the new name. Someone else set up the original query but then the source file changed after they left the company. Thanks again! "Debra Dalgleish" wrote: Do you know what the current source file is? Carl wrote: Thanks, Debra, I really appreciate your help but nothing happens when I click OK. I tried to get Microsoft Query to open by selecting €śData€ť then €śGet External Data€ť, then €śEdit Query€ť which gave me the message, "Query wizard cannot be used to edit this query". I also tried selecting "Data", then "! Refresh Data", which also gave me the same message. Do you have any other suggestions? Thanks in advance. "Debra Dalgleish" wrote: If you click OK, Microsoft Query should open, and you can edit the source file name in the SQL string. Carl wrote: I am trying to edit a query in an Excel worksheet to change the name of the source file but keep getting the message, "Query wizard cannot be used to edit this query". The worksheet is not protected. Does anyone have a suggestion? Thanks in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Query Wizard Cannot Be Used To Edit This Query
Thanks, Debra,
I will try that and let you know how it works. Thanks again. "Debra Dalgleish" wrote: You could try programming to write the connection string to a worksheet. Then, edit the string, and reset the connection. For example, with the query on sheet1: Sub GetQueryInfo() Worksheets("Sheet2").Range("B2").Value _ = Worksheets("Sheet1").QueryTables(1).Connection End Sub Sub SetQueryInfo() Worksheets("Sheet1").QueryTables(1).Connection _ = Worksheets("Sheet2").Range("B2").Value End Sub Carl wrote: No, unfortunately. That is why I am trying to edit it...to find the old name and change it to the new name. Someone else set up the original query but then the source file changed after they left the company. Thanks again! "Debra Dalgleish" wrote: Do you know what the current source file is? Carl wrote: Thanks, Debra, I really appreciate your help but nothing happens when I click OK. I tried to get Microsoft Query to open by selecting €śData€ť then €śGet External Data€ť, then €śEdit Query€ť which gave me the message, "Query wizard cannot be used to edit this query". I also tried selecting "Data", then "! Refresh Data", which also gave me the same message. Do you have any other suggestions? Thanks in advance. "Debra Dalgleish" wrote: If you click OK, Microsoft Query should open, and you can edit the source file name in the SQL string. Carl wrote: I am trying to edit a query in an Excel worksheet to change the name of the source file but keep getting the message, "Query wizard cannot be used to edit this query". The worksheet is not protected. Does anyone have a suggestion? Thanks in advance. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| All times are GMT +1. The time now is 06:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com