Page 517 - Excel 2013 All-in-One For Dummies

Excel 2013 Data Sharing Basics 499
2013 installed) by choosing File➪Save As➪Download and make the more advanced edits to this downloaded copy of the file after you get back to the office.
Reviewing workbooks online
Sometimes you may find yourself working on a computing device that doesn’t have a web browser that supports the Excel web app. For example, when I use the Safari web browser on my iPhone 5 (unlike the version of Safari that runs on my MacBook Air laptop and iPad tablet), the browser opens my workbook files with the Excel Mobile Viewer instead of the Excel web app.
The only problem with this is that the Mobile Viewer only lets you see the data. If after reviewing the data, you find some things that need editing, you’ll have to make a note of them and get yourself to a device running a web browser that supports the Excel web app or, better yet, one on which a full-blown version of Excel 2013 is installed.
Don’t forget about Microsoft’s SkyDrive app for the Apple iPad and iPhone, if you use either of these devices. The free SkyDrive app is available for download from the App Store. This app enables you to access all the Excel workbook files you store on your SkyDrive from your iPad or iPhone. Just be aware that you can only review the worksheets that you open with this app as it is not yet capable, as of this writing, of running the Excel web app. You, however, use the app to send links to the workbook, change the permissions, rename the file, and even open another app that can open Excel workbook files on the these apple mobile devices. Also, on the iPad, you can edit your SkyDrive workbooks with the Excel web app on the Safari web browser.
Excel 2013 Data Sharing Basics
You share information between Excel 2013 and other programs you use in two ways: You either copy or move discrete objects or blocks of data from one program’s file to another, or you open an entire file created with one program in the other program.
The key to sharing blocks of data or discrete objects in Excel is the Windows Clipboard. Remember that Excel always gives you access to contents of the Clipboard in the form of the Clipboard task pane, which you can open by click- ing the Dialog Box launcher in the lower-right corner of the Clipboard group at the beginning of the Home tab on the Ribbon. When the Clipboard task pane is open, you can then copy its objects or blocks of text into cells of the open worksheet simply by clicking the item in this task pane.
Book IV Chapter 4
Sharing Workbooks and Worksheet Data