External Data Ranges

External data ranges are important when you want to use large amounts of data from other sources, including other Excel workbooks, databases or the internet. Once the external data range is created, it can be refreshed and if the information in the source has changed, the updated data will be brought into your workbook. Let's say you have a database with sales information. You can set up an external data range in your Excel workbook to pull down the sales rep and sales figures. Once the data is in Excel, you can perform calculations as necessary. Another example is setting up an external data range to query the internet and retrieve stock quotes. Once the price is in Excel, you can calculate your gain or loss based on the number of shares you own.

Feel free to check out the 2 minute video that shows how to use External Data ranges.

External Data Ranges