Excel 2010 Bible

Chapter 29: Sharing Data with Other Office Applications 619 Notice the two option buttons: Paste and Paste Link. If you select o ...

Part IV: Using Advanced Excel Features 620 FIGURE 29.3 Word paste options when an Excel chart is on the Clipboard. Pasting a lin ...

Chapter 29: Sharing Data with Other Office Applications 621 FIGURE 29.4 The Word paste link options for an Excel range. When an ...

Part IV: Using Advanced Excel Features 622 FIGURE 29.5 Use Word’s Links dialog box to modify or break links. Embedding Objects i ...

Chapter 29: Sharing Data with Other Office Applications 623 Embedding Word documents To embed an empty Word document into an Exc ...

Part IV: Using Advanced Excel Features 624 Embedding an Excel Workbook in a Word Document You can embed an Excel workbook in a W ...

Chapter 29: Sharing Data with Other Office Applications 625 If you double-click the embedded object, you notice that Word’s Ribb ...

Part IV: Using Advanced Excel Features 626 You may have noticed that Microsoft Excel Worksheet Object also appears in the Paste ...

627 CHAPTER Using Excel in a Workgroup IN THIS CHAPTER Using Excel on a network Understanding file reservations Using shared wor ...

Part IV: Using Advanced Excel Features 628 Understanding File Reservations Networks provide you with the ability to share inform ...

Chapter 30: Using Excel in a Workgroup 629 FIGURE 30.1 The File in Use dialog box appears if you try to open a file that someone ...

Part IV: Using Advanced Excel Features 630 Understanding shared workbooks You can share any Excel workbook with any number of us ...

Chapter 30: Using Excel in a Workgroup 631 Caution If you save an Excel 2010 shared workbook to an earlier version file format ( ...

Part IV: Using Advanced Excel Features 632 Controlling the advanced sharing settings Excel enables you to set options for shared ...

Chapter 30: Using Excel in a Workgroup 633 Updating changes While you’re working on a shared workbook, you can choose File ➪ Sav ...

Part IV: Using Advanced Excel Features 634 FIGURE 30.5 Use the Highlight Changes dialog box to track changes made to a workbook. ...

Chapter 30: Using Excel in a Workgroup 635 Keep in mind the following when using the Track Changes feature: l Changes made to ce ...

...

637 CHAPTER Protecting Your Work IN THIS CHAPTER Protecting worksheets Protecting workbooks Protecting Visual Basic Projects Oth ...

Part IV: Using Advanced Excel Features 638 Protecting a Worksheet You may want to protect a worksheet for a variety of reasons. ...