0

Currently, the colorful table is using a fixed URL. I want to send a user-defined, complete URL string to this web query, and have it update whenever it's changed.

The large white box is a pulldown list (AN358):

enter image description here

User can choose a new location:

enter image description here

Which brings up a new URL (AN362) which points to a different web table (always same format). In my case, the colorful table does not change since it's currently a fixed link.

To the right, I converted the blue cells into a new table called "TableYear1" (AN361):

enter image description here

In power editor, here is the existing query "Year 1":

enter image description here

In advanced editor, I tried to replace the web link highlighted here:

enter image description here

With the underlined value here. I know the syntax/usage is probably wrong...it's just to illustrate what I want to accomplish.

enter image description here

Improve this question

1 Answer 1

Reset to default
1

try replacing the code with this

Source = Web.Page(Web.Contents(Excel.CurrentWorkbook(){[Name="TableYear1"]}[Content]{0}[URL1])),

in your example you pass a string (table name), while you need a reference to that table

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

you can record a macro that refreshes just the Year1 table and add a button to press after the selection, the only thing is the workbook has to be macro enabled

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.