Creating Refreshable Web Queries
If you need to analyze web data in a worksheet, you can use the copy and paste commands to bring the data from a web page into the worksheet. The Paste Options button allows you to specify whether you want the information to keep the data as it is right now or make it refreshable to the current data on the web. As the data changes on the web, you can use the Refresh button to quickly update the data in your worksheet. You don’t need to copy the information again.
Copy and Paste Refreshable Data from the Web
Open the web page with the information you want to copy into an Excel worksheet, and then select the data. ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
