[HELP] how this excel file get the table information from this website

how this excel file get the table information from this website,
i can't find which cell adding the url,

when i disconnect my line, it showing can't connect to http://dj.mybank.com.tw/z/zc/zch/zcha_2330.djhtm.
so i need to know which cell is entering the link above.

AttachmentSize
RevenueGrowth.xlsx71.21 KB

RE: How this excel file get the table information from website

Hi,

Go to Ribbon -> Data -> Existing Connections (or Connections). From there you can see the current connections and edit them for example.

 

Best regards.

Ribbon -> Data -> Existing

Ribbon -> Data -> Existing Connections this only can grab the data one cell or new worksheet.

how i can know the existing url link is insert in where?

Existing URL link

Hi,

I'm not sure I understand your question correctly, but let me guess:

go to Ribbon -> Data -> Existing Connections, right-click on the connection, choose Edit Connection Properties...

or

go to Ribbon -> Data -> Connections, select connection, press Properties... button.

Then, go to Definition tab, press Edit Query... button.

Now, you can see and edit, if you need, the connection link.

If this is not what you need, please explain in more details...

 

Best regards.

thank..the edit query can

thank..the edit query can found the URL.

but how i know the URL is in which column?

Sorry

Hi,

Sorry, but I do not understand your question.

Please, explain in more details...

 

Best regards.