Page 181 - Computer - 10(A&B)

Step 2: The Open dialog box will appear. Select the shared Calc spreadsheet and click on Open button. A
message box will appear to inform the user that the spreadsheet is in shared mode and some features
will not work.
Step 3: Click on OK button. The shared spreadsheet opens.

Step 4: Make some changes in the spreadsheet.
Step 5: Now, go to File menu and click on Save option. This will save the shared spreadsheet with new changes.

Sharing a Workbook
When you save a shared spreadsheet, one of several situations may occur:
v If the worksheet was not modified and saved by another user since you opened it, the worksheet is saved.
v If the worksheet was modified and saved by another user since you opened it, one of the following events
will occur:
a. If the changes do not conflict, the worksheet is saved and any cells modified by the other user are shown
with a blue border.
b. If the changes conflict, the Resolve Conflicts dialog box will appear. You must decide for each conflict
which version to keep, yours or the other person’s. When all conflicts are resolved, the worksheet is
saved. While you are resolving the conflicts, no other user can save the shared worksheet.
If another user is trying to save the shared worksheet and resolve conflicts, you see a message that the shared
spreadsheet file is locked due to a merge-in in progress. You can choose to cancel the Save option for now, or
retry saving later.
When you successfully save a shared spreadsheet, the worksheet shows the latest version of all changes that got
saved by all users.

Knowledge Plus
Knowledge Plus
Most spreadsheet software automatically turn off some features in shared workbooks to simplify the workbook
since multiple people can be working on the file at the same time. For example, shared workbooks don‘t allow
merging cells, conditional formatting, or inserting pictures/graphs/etc.

Recording Changes
You can use several methods to record changes that you or others make to a document:
v You can use change marks to show added material, deleted material, and changes to formatting. Later, you or
another person can review the document and accept or reject each change. This is not available for shared files.
v If you are not using file sharing, you can make changes to a copy of the document (stored in a different
folder, under a different name, or both), then use Calc to compare the files and show the changes.
v You can save versions that are stored as part of the original file.
Reviewers can leave comments in the document, either attached to specific changes or standalone.

Record Changes

This feature is not available in shared documents. When you send a document to someone else to review or edit,
you may want to set it up so that the editor or reviewer does not have to remember to turn on the revision marks.

63