Chapter 13. Sharing Excel Data

Sharing Excel Data

You can share Excel data between worksheets, workbooks, and with other users. This chapter shows you how to use a variety of data-sharing methods, including linking data, tracking multiple-user changes to workbook files, and e-mailing Excel data.

Link Data

You can use OLE technology to share data from your Excel worksheets. OLE stands for object linking and embedding. For example, you might link data from one workbook to another, or link Excel data to a Word or PowerPoint file.

Ordinarily, when you copy data, the data does not retain any connection to its source. With linking, the data retains a connection to its source, ...

Get Teach Yourself VISUALLY™: Excel® 2007 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.