Lưu file excel báo lỗi because of a sharing violation năm 2024
Đây là một lỗi khá phổ biến khi người dùng chuyển từ win7 sang win10 hoặc chuyển từ các đời office cũ hơn sang đời office mới hơn. Show
Sau đây là giải pháp dành cho em nó: Nếu như file nằm trên ổ C thì khi save không bị báo lỗi gì, nhưng nếu nằm trên các ổ khác (ví dụ: ổ D) thì đều bị báo lỗi: “Your changes could not be saved to … ” Mình đã khắc phục được bằng cách sau: Vào my computer, nhấn chuột phải ổ D, properties, chọn tab security, chọn user đang sử dụng, nhấn edit, và cấp quyền full control cho user này (tick vào dòng full control ở cột allow) là được. Nếu thấy hay hãy vote 5 sao giúp mình ở phía dưới nhé. For English :In Drive OS (C drive) is OK, but other Drive is warning trouble “Your changes could not be saved to … ” Solution for this problem is: Win7: Open my computer, if drive D has file excel in trouble. Right click on D drive icon, Choose Properties, Choose Tab Security, Choose your user (maybe everyone, Alex PC, ….). Click Edit. Choose Full controll. Choose Allow. OK to finish. It is not uncommon to encounter errors while working with Excel application. One common error that Excel users face is the sharing violation error that occurs while saving an Excel spreadsheet. The complete error message says, “Your changes could not be saved to file because of a sharing violation.” When this error occurs, users won’t be able to save the changes in the file. So, it is important to fix this issue as soon as possible. But before fixing the error, let’s find out the causes behind this error. Causes of Excel Sharing Violation ErrorThis error may pop up due to the below reasons:
Methods to Fix the Sharing Violation Error in ExcelYou can move the affected Excel file to a new folder and save it with a different name. Then, see if it fixes the error. If it doesn’t help, you can try the below methods. Method 1: Check and Change the Excel File PropertiesYou can get the sharing violation error in Excel if the file attribute options, such as “File is ready for archiving” and “Allow this file to have contents indexed in addition to file properties” are disabled. You can check the File Properties and enable these options to fix the issue. Here are the steps:
Note: If these options are already selected, then unselect and re-select them. Method 2: Enable Sharing Wizard OptionThe error “Your changes could not be saved to file because of a sharing violation” can also occur if the sharing wizard option is disabled on your system. You can check and enable the sharing wizard option using these steps:
Method 3: Move the Excel File to a Trusted LocationYou can encounter the sharing violation error if the file you are trying to save is not in the trusted location. You can try moving the file to a trusted location by following these steps:
Method 4: Open Excel in Safe ModeIncompatible add-ins can create issues in the Excel file. To check if the sharing violation issue has occurred due to add-ins, open Excel in safe mode. To do so, follow these steps:
Method 5: Repair the Excel FileCorruption in Excel file can also create issue while saving the changes. In such a case, you can repair the corrupted Excel file using the inbuilt utility in Excel, named Open and Repair. Follow these steps to use this utility:
If the above utility fails to fix the corrupt Excel file, then you can use a more powerful Excel repair tool, such as Stellar Repair for Excel. This Excel repair tool can repair even severely corrupted or damaged Excel files (xls, .xlsx, .xltm, .xltx, and .xlsm). This tool can recover all the data from the corrupted Excel file, including images, chart sheets, formulas, etc., without changing the original format. It can help in fixing common corruption-related errors in Excel. You can download the software’s demo version to scan the corrupt file. To ConcludeAbove, we have discussed some effective methods to fix the sharing violation error in Excel. This error may also occur if you try to save the Excel file in an incompatible format. So, check the format and try saving the file in a compatible format. If the error occurs due to Excel file corruption, you can repair corrupt Excel file using the Open and Repair tool. If nothing works, then download a third-party Excel repair tool, such as Stellar Repair for Excel. It is an advanced tool that can fix severely corrupted Excel files. You can install this repair tool on any Windows system. |