Data from External Source

Hi Heather,

Thank you for the forum question.

It is a very interesting option in Excel linking to websites.

From the DATA tab in the ribbon in the GET EXTERNAL DATA group click FROM WEB. Type the address to the website in the ADDRESS field and press the GO button. The tables you can link to Excel will on the website be represented by yellow boxes with an arrow inside. Click on the yellow box representing the table you want to link to Excel. Click the IMPORT button in the bottom right corner of the Excel web browser. A IMPORT DATA dialog box will appear. Click PROPERTIES if you want to set properties for the link (you can tell Excel how often you want to refresh the link).

On the course we used Bank of England as an example.

http://www.bankofengland.co.uk/boeapps/iadb/Rates.asp

If you add the link above to the Excel web browser and click GO you will get to Bank of England's currency rates. You will find the yellow box with and arrow in the top left corner on the website. Click the box and click IMPORT.

I hope this can help you.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector