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
Sharing Information Between Programs
Excel can convert data or text from one format to another using a technology known as object linking and embedding (OLE). OLE allows you to move text or data between programs in much the same way as you move them within a program. The familiar cut and paste or drag and drop methods work between programs and documents just as they do within a document. In addition, Excel and all Office programs have special ways to move information from one program to another, including importing, exporting, embedding, linking, and hyperlinking.
Importing and Exporting
Importing and exporting information are two sides of the same coin. Importing copies a file created with the same or another program into your open file. The ...