尝试在计算机上保存 Microsoft Excel 电子表格时(error while trying to save a Microsoft Excel spreadsheet)出现“共享冲突”错误？您可能没有将文件保存到文件夹中所需的权限。此问题还有其他原因，我们将向您展示如何解决所有这些问题，以便您成功保存文件。
无法保存对MS Excel文件的更改的其他原因包括防病毒程序正在干扰您的文件、电子表格文件夹的文件内容索引被禁用、Excel应用程序本身存在问题等等。
获取网络文件夹(Your Network Folder)所需的权限(Required Permissions)
如果您在尝试将电子表格保存到网络驱动器上时(error while trying to save your spreadsheet on a network drive)遇到“共享冲突(Violation)”错误，请确保您拥有执行此操作的正确权限。您需要修改(Modify)和删除(Delete)权限才能将文件保存到网络文件夹中。
由于您没有所需的权限，请要求您的网络管理员授予您上述两项权限。管理员完成此操作后，您将能够将文件保存在所需的网络位置。
在Windows 文件资源管理器(Windows File Explorer)中打开共享向导(Sharing Wizard)
您收到“共享冲突”错误的另一个原因是您没有在文件资源管理器应用程序中启用共享(File Explorer)向导(Wizard)。值得在 Windows PC 上打开此功能(feature on your Windows PC)以消除错误。
- (Open File Explorer)Windows + E打开电脑上的文件资源管理器。
- 选择文件资源管理器(File Explorer)顶部的三个点，然后选择选项。
- 访问打开的窗口中的
“查看”选项卡。(View)
- 启用“高级设置”部分中的(Advanced)“使用共享向导(Use Sharing Wizard)（推荐）”选项。
- 选择“应用”(Select Apply)，然后选择底部的“确定”。
- 尝试保存Excel文件中的更改。
将Excel 电子表格(Excel Spreadsheet)保存在本地(Your Local)存储
上
修复Excel错误的一种方法是将电子表格保存到计算机的本地存储中(saving your spreadsheet to your computer’s local storage)。这可以帮助您绕过任何与网络相关的问题并成功保存文件。如果需要，您可以手动将文件传输到网络驱动器。
- 选择(Select File)Excel 左上角的“文件”。
- Choose Save As > Browse在以下屏幕上
选择“另存为”>“浏览” 。
- 选择本地存储上的一个文件夹来保存文件，然后选择“保存”(Save)。
根据您将计算机连接到网络的方式，您可以使用计算机的文件管理器应用程序复制保存的Excel文件并将其粘贴到网络文件夹中。
使用新(New)名称保存Excel(Excel File)文件
如果保存Excel文件时仍然遇到问题，请为文件使用其他名称(use a different name for your file)并尝试保存该文件。这将帮助您解决任何与名称相关的冲突，使您能够顺利保存文件。
- 打开电子表格后，选择Excel 左上角的
“文件” 。(File)
- Choose Save As > Browse在接下来的页面中
选择“另存为 > 浏览” 。
- 选择一个文件夹来保存文件。选择“文件(File)名”字段并输入与当前名称不同的名称。然后，选择保存(Save)。
关闭您的防病毒程序
您收到“共享违规”错误的一个可能原因是您的防病毒程序阻止了您对文件的访问。有时，防病毒程序会产生误报结果，从而导致各种错误。
在这种情况下，请暂时禁用防病毒程序，然后查看是否可以保存文件。保存文件后，您可以重新打开防病毒软件。
如何关闭防病毒保护取决于您所使用的程序。您可以按照以下说明禁用 Microsoft Defender 防病毒软件(disable Microsoft Defender Antivirus)：
- 打开“开始”(Start)，找到“Windows 安全”(Windows Security)，然后启动该应用程序。
- (Select Virus)在应用程序的主屏幕上
选择病毒和威胁防护。
- 选择(Choose Manage)病毒(Virus)和威胁防护设置
下的管理设置。
- 禁用实时保护选项。
- (Choose Yes)在用户帐户控制提示中(User Account Control)选择是。
- 打开Excel文件并进行所需的更改。然后，保存您的文件。
- 重新打开防病毒保护。
如果上述方法已解决您的问题，请联系您的防病毒提供商以寻求问题的永久解决方案。
打开电子表格文件夹的索引(Your Spreadsheet Folder)
您可以打开一个Windows选项来修复Excel “共享冲突”错误。除了文件属性之外，
此选项还会对文件夹中文件的内容进行索引。(This option indexes the contents of the files in your folder)
- 找到您尝试保存Excel文件的文件夹。
- 右键单击您的文件夹并选择属性。
- 选择常规(General)选项卡并选择高级(Advanced)。
- 除了文件属性之外，打开允许此文件夹中的文件将内容编入索引选项。(Allow)
- 选择“确定”、“应用”和“确定”。
修复您的 Microsoft Excel 应用程序
如果错误消息尚未消失，最后的办法是修复Microsoft Excel应用程序本身。该应用程序可能遇到问题，产生各种错误。
幸运的是，您不需要做太多事情来修复您的应用程序。Microsoft Office包含一个修复工具，只需单击几下即可修复所有 Office 应用程序。(fix all your Office apps)您可以使用此工具来解决Excel(Excel)应用程序遇到的
所有问题。
- 打开“开始”(Start)菜单，找到“控制面板”(Control Panel)，然后启动该实用程序。
- (Select Uninstall)在“控制面板”中(Control Panel)选择“卸载程序” 。
- 在列表中选择您的Microsoft Office安装，然后选择顶部的“更改” 。(Change)
- 在用户帐户控制(User Account Control)提示中选择是(Yes)。
- 选择“快速修复”(Choose Quick Repair)，然后选择“修复”(Repair)。
- 如果您的问题未得到解决，请选择“在线修复”(Online Repair) ，然后在工具中
选择“修复” 。(Repair)
(Multiple Ways)解决 Excel 共享冲突错误的(Violation Error)多种方法
Microsoft Excel 显示上述错误消息的(Microsoft Excel displays the above error message)原因有多种。修复可能导致问题的项目后，您可以解决错误并将Excel电子表格保存在所需位置。我们希望该指南可以帮助您保存对Excel(Excel)文件的更改。
Microsoft Excel “Sharing Violation” Error: Causes and How to Fix
Getting a “Ѕharing Violаtion” error while trying to save a Microsoft Excel spreadsheet on your computer? You may not have the required permissions to save the file in your folder. There are other causes of this issue, and we’ll show you how to resolve all those items to let you save your file successfully.
Other reasons you can’t save changes to your MS Excel file are that your antivirus program is interfering with your file, file content indexing is disabled for your spreadsheet folder, the Excel app itself has problems, and more.
Get the Required Permissions for Your Network Folder
If you’re getting the “Sharing Violation” error while trying to save your spreadsheet on a network drive, ensure you have the correct permissions to do so. You need both Modify and Delete privileges to save files on your network folder.
Since you don’t have the required permissions, ask your network administrator to grant you both of the above permissions. Once the admin has done that, you’ll be able to save your file at your desired network location.
Turn On the Sharing Wizard in Windows File Explorer
Another reason you get a “Sharing Violation” error is that you don’t have Sharing Wizard enabled in your File Explorer app. It’s worth toggling on this feature on your Windows PC to get rid of your error.
- Open File Explorer on your PC by pressing Windows + E.
- Select the three dots at the top of File Explorer and choose Options.
- Access the View tab in the open window.
- Enable the Use Sharing Wizard (Recommended) option in the Advanced settings section.
- Select Apply followed by OK at the bottom.
- Try to save changes in your Excel file.
Save Your Excel Spreadsheet on Your Local Storage
One way to fix your Excel error is by saving your spreadsheet to your computer’s local storage. This helps you bypass any network-related issues and save your file successfully. You can then manually transfer the file to your network drive if you wish.
- Select File in Excel’s top-left corner.
- Choose Save As > Browse on the following screen.
- Choose a folder on your local storage to save your file and select Save.
Depending on how you’ve connected your computer to your network, you can use your machine’s file manager app to copy your saved Excel file and paste it on your network folder.
Save Your Excel File With a New Name
If you still have trouble saving your Excel file, use a different name for your file and try to save the file. This will help you resolve any name-related conflicts, allowing you to save your file without issues.
- While your spreadsheet is open, select File in Excel’s top-left corner.
- Choose Save As > Browse on the following page.
- Select a folder to save your file in. Choose the File name field and enter a name different from the current one. Then, choose Save.
Turn Off Your Antivirus Program
One possible reason you get a “Sharing Violation” error is that your antivirus program has blocked your access to your file. Sometimes, antivirus programs produce false-positive results, leading to various errors.
In this scenario, temporarily disable your antivirus program and see if you can then save your file. You can turn your antivirus back on when you’ve saved the file.
How you turn off your antivirus protection depends on the program you’re using. You can follow the following instructions to disable Microsoft Defender Antivirus:
- Open Start, find Windows Security, and launch the app.
- Select Virus & threat protection on the app’s main screen.
- Choose Manage settings beneath Virus & threat protection settings.
- Disable the Real-time protection option.
- Choose Yes in the User Account Control prompt.
- Open your Excel file and make the desired changes. Then, save your file.
- Turn your antivirus protection back on.
If the above has fixed your issue, reach out to your antivirus provider to seek a permanent solution to the problem.
Turn On Indexing for Your Spreadsheet Folder
You can turn on one Windows option to potentially fix your Excel “Sharing Violation” error. This option indexes the contents of the files in your folder in addition to your files’ properties.
- Find the folder where you’re trying to save your Excel file.
- Right-click your folder and choose Properties.
- Select the General tab and choose Advanced.
- Turn on the Allow files in this folder to have contents indexed in addition to the file properties option.
- Choose OK, Apply, and OK.
Repair Your Microsoft Excel App
If your error message hasn’t gone away yet, your last resort is to fix the Microsoft Excel app itself. The app may be experiencing issues, producing various kinds of errors.
Luckily, you don’t have to do much to repair your app. Microsoft Office includes a repair tool that allows you to fix all your Office apps in a few easy clicks. You can use this tool to fix all the issues that your Excel app is experiencing.
- Open the Start menu, find Control Panel, and launch the utility.
- Select Uninstall a program in Control Panel.
- Choose your Microsoft Office installation on the list and select Change at the top.
- Select Yes in the User Account Control prompt.
- Choose Quick Repair and select Repair.
- If your issue isn’t resolved, choose Online Repair and select Repair in the tool.
Multiple Ways to Get Around Excel’s Sharing Violation Error
Microsoft Excel displays the above error message for various reasons. Once you fix the items that may potentially be causing the problem, you can resolve your error and save your Excel spreadsheet at the desired location. We hope the guide helps you save changes to your Excel files.
