word - Open the Cooking workbook located in the Excel12 >...

This preview shows page 1 - 3 out of 48 pages.

Open the Cooking workbook located in the Excel12 > Module folder included with your Data Files, and then save the workbook as Cooking Craft in the location specified by your instructor. 2 In the Documentation worksheet, enter your name and the date. 3 On the ribbon, click the File tab, and then click Options in the navigation bar. The Excel Options dialog box opens. 4 In the left pane, click Trust Center , and then in the right pane, click the Trust Center Settings button. The Trust Center dialog box opens. 5 In the left pane, click Privacy Options . 6 In the Document-specific settings section, verify that the Remove personal information from file properties on save check box is either not selected or not selected and grayed out so that Excel will share and save the workbook without having to remove any personal information. 7 Click the OK button in each dialog box to return to the workbook. The privacy options are reset for the workbook. Next page On the ribbon, click the Review tab. In the Changes group, click the Share Workbook button. The Share Workbook dialog box opens with the Editing tab active. 2 Click the Allow changes by more than one user at the same time. check box to insert a checkmark. This allows others to access and edit this workbook. Notice that your name appears as the exclusive user in the Who has this workbook open now box. 3
Image of page 1

Subscribe to view the full document.

Click the OK button. A dialog box opens, indicating that the workbook will be saved. 4 Click the OK button. The workbook is saved, and “[Shared]” appears on the title bar next to the workbook name. 5 Close the workbook. Nexct Main content Chapter Contents 12-3 Tracking Changes in a Workbook Once a workbook has been shared, Excel will track the changes made to the workbook, recording the name of the user who made the changes and when the changes were saved. You can use the Share Workbook dialog box to monitor who else is accessing the document and when they first started editing the file. For example, Marta shared her workbook with John Andersen, who also began to edit the workbook. Figure 12-1 shows the Share Workbook dialog box listing who is accessing the workbook. Figure 12-1Share Workbook dialog box When two or more people edit a workbook simultaneously, Excel will notify each user of the changes saved by others. Consider the situation shown in Figure 12-2 , in which Marta Filipovic and John Andersen are editing the same workbook at the same time. John edits the value in cell B5, and then saves the workbook. When Marta saves the workbook a little later, John’s edit appears as a comment attached to the changed cell, notifying Marta what John did. Excel removes these comments automatically when the workbook is closed but saves the edit history for 30 days.
Image of page 2
Image of page 3
  • Summer '17
  • Computer file, Marta Filipovic

{[ snackBarMessage ]}

Get FREE access by uploading your study materials

Upload your study materials now and get free access to over 25 million documents.

Upload now for FREE access Or pay now for instant access
Christopher Reinemann
"Before using Course Hero my grade was at 78%. By the end of the semester my grade was at 90%. I could not have done it without all the class material I found."
— Christopher R., University of Rhode Island '15, Course Hero Intern

Ask a question for free

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern