Excel 2016工作簿的最终版本完成后，您可能希望停止或关闭 Excel 中的工作簿共享，^{( stop or turn off the workbook sharing in Excel)}以避免任何不需要的更改。但是，在停止共享工作簿之前，请确保已容纳所有最终更改或添加，因为任何未保存的更改都将丢失。更改历史记录^{(Change history)}也将被删除。以下是如何去做。

如何在Excel中关闭工作簿共享^(Excel)

首先，复制更改历史信息。为此，请单击Changes Group of Review选项卡下可见的“Track changes”选项。

接下来，点击突出显示更改^{(Highlight Changes)}按钮。在“时间”列表中，选择“全部”并清除“谁”^(Who)和“地点”^(Where)复选框。

现在，选中“在新工作表上列出^(List)更改”复选框，然后单击“确定”。现在，执行以下操作

将历史记录复制到另一个工作簿。选择要复制的单元格，切换到另一个工作簿，然后放置复制的数据。此后^(Thereafter)，在共享工作簿中，转到Review选项卡，然后在Changes组下，单击Share Workbook。

清除“允许多个用户同时更改”选项。这也允许工作簿合并复选框。出于某种原因，如果您发现复选框不可见，请取消保护工作簿。现在，要删除共享工作簿保护，请执行以下操作：

单击“确定^{(Click OK)}”关闭“共享工作簿^{(Share Workbook)}”对话框。

切换到Review选项卡，在Changes组中，单击Unprotect Shared Workbook。

当提示输入密码时，输入密码并点击 OK 按钮。

然后，在Review选项卡上的Changes组中，单击Share Workbook。

此后，在“编辑^(Editing)”选项卡中，清除“允许^(Allow)多个用户同时更改”。这也允许工作簿合并复选框。当寻求您对对其他用户的影响进行更改的许可时，单击是^(Yes)。

That’s it!

How to stop or turn off Workbook Sharing in Excel

Once the finаl verѕion оf your Excel 2016 workbook is complete you might want to stop or turn off the workbook sharing in Excel to avert any unwanted changes. However, before stopping the sharing of a workbook, ensure all the final changes or additions have been accommodated because any unsaved changes will be lost. The Change history will also be deleted, alongside. Here’s how to go about it.

How do you turn off workbook sharing in Excel

First, copy the change history information. For this, click ‘Track changes’ option visible under the Changes Group of Review tab.

Next, hit the Highlight Changes button. In the When list, select All and clear the Who and Where checkboxes.

Now, select the List changes on a new sheet check box, and then click OK. Now, do the following

Copy the history to another workbook. Select the cells that you would want to copy, switch to another workbook, and place the copied data. Thereafter, in the shared workbook, go to the Review tab, and under the Changes group, click Share Workbook.

Clear the ‘Allow changes by more than one user at the same time’ option. This also allows the workbook merging check box. For some reason, if you find the checkbox is not visible, unprotect the workbook. Now, to remove shared workbook protection, do the following:

Click OK to close the Share Workbook dialog box.

Switch to the Review tab, in the Changes group, click Unprotect Shared Workbook.

When prompted for the password, enter the password and hit the OK button.

Then, on the Review tab, in the Changes group, click Share Workbook.

Thereafter, In the Editing tab, clear the Allow changes by more than one user at the same time. This also allows the workbook merging check box. When your permission for making changes about the effects on other users is sought, click Yes.

That’s it!

Related posts

• 如何修复损坏的Excel Workbook

• 如何申请Themes和改变的Excel Workbook外观

• 如何在Excel中使用Percentile.Exc function

• 如何使用NETWORKDAYS function在Excel

• 如何计算在Excel的Yes or No entries数

• 如何将一列拆分为Excel中的多列

• 如何更改默认File Format，用于保存Word，Excel，PowerPoint

• 如何编写，构建和使用VLOOKUP function在Excel

• 如何在Windows 11/10中创建Radar Chart

• 运行时error 1004，不能在Excel运行Macro

• Excel中Mean的Calculate Standard Deviation and Standard Error

• 如何在Excel中计算列中的重复值

• 如何在Excel中使用ISODD function

• 如何在Microsoft Excel中使用HLOOKUP function

• 如何启动Word，Excel，PowerPoint，Outlook在Safe Mode

• 如何在Excel中使用Automatic Data Type feature

• Microsoft Excel Tutorial，用于初学者

• 如何在Excel创建和使用Form Controls

• Microsoft Excel在Windows 10运行时导致High CPU usage

• 如何在Excel中使用DEC2Bin将十进制数转换为二进制数