February 2013
Beginner to intermediate
576 pages
21h 30m
English
Content preview from Excel® 2013 On Demand
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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. ...