Microsoft 365 and Office | Excel | For home | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
You can't in mac Excel. You have to edit the query with a text editor.
Excel Edit Web Query
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I am using Excel 2011 for mac. I have created web queries using .iqy files. However, when I click on the query in Excel, and click on "Edit Query" nothing happens. How can I edit to query in Excel?
Microsoft 365 and Office | Excel | For home | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
7 answers
Sort by: Most helpful
-
Anonymous
2013-02-18T17:58:09+00:00 -
Anonymous
2013-02-18T19:15:29+00:00 Maybe this will help somewhat.
-
Anonymous
2013-02-18T18:51:46+00:00 Is there a way to store cookies, so that I can use web queries in Excel for mac, to download from pages that require login.
Eric
-
Anonymous
2013-02-18T18:33:12+00:00 The facility to edit Web queries as is done in Windows is simply not available on the Macintosh. If you would like to see this feature, use send feedback in the help menu to tell Microsoft.
-
Anonymous
2013-02-18T18:05:33+00:00 Thank you Bob.
The reason that I want be able to edit the query like I do in Windows' Excel, is because it allows me to sign into a website, and query data that is only available after sign in. Do you know of another way I can do this so I can continue using Excel?
Eric