Home » Forums » Open Source Learning Center » Question and Answer

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

Submitted by mampwamp2 on 21 December, 2012 - 08:07

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
‹ Formula showing up in cell which are the best online course Microsoft Excel 2010 for Beginners? ›
»

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

Submitted by manny on 21 December, 2012 - 11:16.

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

Submitted by mampwamp2 on 23 December, 2012 - 03:16.

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

Submitted by manny on 23 December, 2012 - 12:34.

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

Submitted by mampwamp2 on 26 December, 2012 - 06:51.

thank..the edit query can found the URL.

but how i know the URL is in which column?

»

Sorry

Submitted by manny on 26 December, 2012 - 16:06.

Hi,

Sorry, but I do not understand your question.

Please, explain in more details...

 

Best regards.

»