Page 501 - Excel 2013 All-in-One For Dummies
P. 501
Workbooks on Review 483
It’s always a good idea to inform the users of your shared workbook of your intention to remove the file from shared use well in advance of the actual date. Your best bet is to e-mail each user and let him or her know exactly the date and time after which the workbook will no longer be shared and open to their edits. That way, each person on the team knows the exact time after which his or her changes and comments will no longer be accepted (which is often a good inducement for the procrastinators on the team to send you their last-minute suggestions and changes).
Removing a user from the shared workbook
Sometimes, rather than preventing everyone from sharing a particular work- book, you may only need to stop particular users from being able to edit it. To remove a specific user from sharing in the editing, you open the Share Workbook dialog box (Alt+RW), click the name of the person you want to remove in the Who Has the Workbook Open Now list box, and then click the Remove User button.
As soon as you click this button, Excel displays an alert dialog box informing you that if the user you selected is currently editing the workbook, your action will prevent him or her from saving the workbook so that all unsaved work is automatically lost. To proceed with removing the user, click the OK button in this alert dialog box. To abandon the removal until after you’ve verified that the user isn’t currently editing the file, click the Cancel button instead.
Workbooks on Review
Even if you don’t save your workbooks on a SkyDrive or use Excel on a net- work, you still can add your comments to the cells of a workbook that ask for clarification or suggest changes, and then you can distribute copies of the workbook by e-mail to other people who need to review and, perhaps, respond to your remarks. Excel makes it easy to annotate the cells of a work- sheet, and the command buttons on the Review tab of the Ribbon make it easy to review these notes prior to e-mailing the workbook to others who have to review the comments, and even reply to suggested changes.
If you’re running Excel 2013 on a computer equipped with a digital tablet or on a touchscreen device such as a Windows tablet, the Review tab of your Ribbon has a Start Inking command button (not included on this tab when running Excel on a regular PC). When you click the Start Inking command button, Excel adds an Ink Tools contextual tab to the Ribbon. You can then use the command buttons on its Pens tab to highlight and mark up various parts of the spreadsheet with digital ink.
Book IV Chapter 3
Sending Workbooks Out for Review