I have a Excel file with a web query. When I right-click the data to edit Query, it opens a web brower which opens the work API from which I get data. I can edit the query in the URL of the browser.
Also, when I right-click the Connection properties and edit Connection, it shows the Connection string which contains the query I want to edit but the text it is not editable here. Clicking edit opens the browser again.
Needless to say this is a huge pain as I need to query slightly different data all the time. Is there a way to edit the web query URL by using input in a cell in Excel itself?
For example if the URL query is
api.work.com/availableqty/A
and I want to change it to
api.work.com/availableqty/B
How I do this without opening the browser?
Also, when I right-click the Connection properties and edit Connection, it shows the Connection string which contains the query I want to edit but the text it is not editable here. Clicking edit opens the browser again.
Needless to say this is a huge pain as I need to query slightly different data all the time. Is there a way to edit the web query URL by using input in a cell in Excel itself?
For example if the URL query is
api.work.com/availableqty/A
and I want to change it to
api.work.com/availableqty/B
How I do this without opening the browser?
