This way you’ll always have the latest data. You can also select to have Excel update the data every time you open the file. By default, Excel will refresh the data every 60 minutes, but you can make it update much more often. Or, if you’d like to make sure the data is automatically refreshed more often, select one of your dynamic cells in Excel and then click the click the Properties button under Connections in the Data tab.Ĭheck the Refresh every box, and enter the number of minutes you want. This will query the website for the latest data and update your spreadsheets. If you’re concerned your data might be stale, click the Refresh All in the Data tab. The great thing is, all of these will will automatically update whenever your web data is updated. Sparklines are a new feature in Excel 2010 and you might want to check out how to use them. You can use it in Graphs, Sparklines, and Formulas.
Now you can manipulate the dynamic data just like you would any other Excel data. You may end up with a few extra cells and columns with unnecessary data, so feel free to remove any data you don’t want to use. You’ll see a message in the spreadsheet that Excel is getting the data.Īfter a few moments, your web data will appear in Excel just like normal. Select where you want Excel to place your web data, and click Ok.
