For more information about this change, read this blog post. If you want several users to work in the same Excel workbook simultaneously, you can save the workbook as a shared workbook. Users can then enter data, insert rows and columns, add and change formulas, and change formatting. It is not possible to open shared workbooks that are created in Microsoft Excel 95 in later versions of Excel and still maintain their shared status.
To make changes to a shared workbook that was created in Microsoft Excel 97 or a later version of Excel, you must use Excel 97 or a later version of Excel. For the detailed step-by-step instructions, please see:. When deciding to share your Excel file, please be aware that it may cause some troubles to your users because not all features are fully supported in shared workbooks.
Here are some of the limitations:. In fact, you will be able to use the existing features, but you won't be able to add or change them. So, if you'd like to benefit from any of the above options, be sure to apply them before sharing your Excel file. The complete list of features unsupported in shared workbooks can be found on Microsoft's web-site.
Now, you can input and edit data as usual, keeping in mind the following limitations of shared workbooks. When two or more users are editing the same workbook simultaneously, some edits can affect the same cell s. In such situations, Excel keeps the changes of the user who saves the workbook first.
When another user tries to save the workbook, Excel displays the Resolve Conflicts dialog box with the details about each conflicting change:. To have the most recent changes automatically override any previous changes made by you or by other users , without displaying the Resolve Conflicts dialog box, do the following:. To view all the changes that have been made to the shared workbook, use the Track Changes feature on the Review tab, in the Changes group.
It will show you when a particular change was made, who made it, and what data was changed. For more information, please see:. In some situations, it can be more convenient to save several copies of a shared workbook, and then merge changes made by different users.
Here's how:. The changes by different users are merged into a single workbook. Now you can highlight the changes , so you can view all the edits at a glance. Sharing an Excel file for multiple users can result in many conflicting changes.
Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment. All images are subject to review.
Commenting privileges may be curtailed if inappropriate images are posted. Who is allowed to turn off sharing? Is it only the creator or can anyone do it? Got a version of Excel that uses the ribbon interface Excel or later? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface. View the most recent newsletter.
Toggle navigation. You can turn off sharing by following these steps: Display the Review tab of the ribbon. Click the Share Workbook tool, in the Changes group. Excel displays the Share Workbook dialog box. There are a couple of Enter your address and click "Subscribe. Your e-mail address is not shared with anyone, ever.
Maximum image size is 6Mpixels. Images larger than px wide or px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted. There are currently no comments for this tip. Be the first to leave your comment—just use the simple form above! This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
View the most recent newsletter. Toggle navigation. You can share a workbook in this way: Load the workbook you want to share. Choose Share Workbook from the Tools menu.
0コメント