
When it’s time to verify the updates made by other users and compile the final version of the document, the workbook owner can compare and merge workbooks using the command of the same name. And, when all changes have been made, you can stop sharing the workbook. If you’re the owner of the shared workbook, you can manage it by removing users from the shared workbook and resolving conflicting changes. For example, shared workbooks don’t allow merging cells, conditional formatting, or inserting pictures or graphs – and some formatting changes are not tracked by the Track Changes feature. This is to simplify the workbook and avoid confusion since multiple people can be working on the file at once. It’s very important to note that Excel automatically turns off some features in shared workbooks. If the “Track changes while editing” check box is not selected, Microsoft Excel has not recorded any change history for the workbook.
On the Tools menu, point to Track Changes, and then click Highlight Changes. Click OK and, if you are prompted to save the workbook, click OK. Under track changes, click “Keep change history for” and, in the days box, type the number of days of change history that you want to keep. On the Editing tab, select the “Allow changes by more than one user at the same time” check box. To turn on change tracking for a workbook: You can also track changes in a shared workbook to see what other people have done to it. It’s also a good idea to take a look at the advanced options to get a sense of how the shared workbook operates. There is an advanced tab in the dialogue box as well, but it is mostly for personalisation preferences, such as how changes are tracked and implemented into the file. When someone edits the file and saves it, everyone will see the updates immediately.
Now your workbook is shared and can be edited by multiple people at the same time.
If this is an existing workbook, click OK to save the workbook, click File tab, and then click Save As. If this is a new workbook, type a name in the File name box. On the Advanced tab, select the options that you want to use for tracking and updating changes, and then click OK. This also allows workbook merging check box. On the Editing tab, select the Allow changes by more than one user at the same time. On the Review tab, in the Changes group, click Share Workbook. To enable a shared workbook, do the following: Maintaining just one workbook can result in less confusion and an up-to-date, easily accessible version of the file for all users. But sometimes you need to have multiple users editing a file at once. This appears because someone else already has the file open. If you share documents, the following warning might be familiar to you: “The document is locked for editing by another user.” With that in mind, here are a few tips for using Excel to make office collaboration smoother and smarter. Document sharing can lead to greater efficiency and collaboration, but can also be a headache when multiple users are accessing and adapting the same content – especially when it comes to Microsoft® Excel®. In most office settings there is a shared drive where teams can store common files for everyone to use.