Cara Mengatasi Microsoft Excel may be able to save the file by removing or repairing some features

Masalah “excel encountered errors during save”  atau pada istilah lainnya bisa disebut error “Unable to Save Workbook “biasanya kita jumpai saat kita akan menyimpan suatu file di Microsoft Excel .

Dan jika tekan tombol “OK” akan muncul kembali pesan error :

“Errors were detected while saving <nama workbook > Microsoft Excel may be able to save the file by removing or repairing some features. To make repairs in a new file, click Continue. To cancel saving the file, click Cancel.”

Jika Anda mengklik Continue, Anda mendapatkan lagi kode error  berikut: “Excel encountered errors during save. However, Excel was able to minimally save your file to <nama file>.”

Masalah ini sebenarnya  berdampak pada versi Versi 1707 (Build 8326.2086) dan kemudian, dan juga hanya terjadi dengan file yang disimpan secara lokal, seperti di desktop. Masalah ini tidak terjadi jika Anda memasukkan nilai secara manual atau menyisipkan suatu bagan di lembar kerja yang baru dibuat (Workbook baru).

Untuk Mengatasi masalah ini sebenarnya cukup sederhana, cukup ikuti beberapa langkah mudah dibawah ini :

Caranya :

• Klik Menu Option di MS Excel
• Klik Languange
• Pada Pilihan Choose Editing languanges ubah English (U.S) Menjadi Default
• Klik OK

Jika Cara Pertama tidak berhasil Silahkan ikuti cara kedua dibawah ini dengan cara Me-Repair Microsoft Office Anda

2. Repair Microsoft Office

Caranya :

• Buka Control Panel > Programs and Features > Microsoft Office
• Klik Kanan Pada Microsoft Office kemudian klik Change
• Klik Repair > OK
• Tunggu Proses Repair sampai Selesai

File | 3 min read| Easton Torres | Updated On - November 17, 2022

Microsoft Excel has been known for mystically simplifying the sophisticated statistical and engineering calculations in no time. The best part of the application is real-time data interpretation through pie-charts and bar graphs that makes your work recognized. However, scenario differs a bit when you try to copy some figures from the first file and makes numerous attempts to close it. All the time the system flashes a single message:

“Errors were detected while saving ‘[path\Filename]’. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel.”

It is quite visible in the most instances where the parent file does not get close and even does not permit to save any changes either in the path or in filename.

The issue of not saving the recent changes in Excel sheet may occur due to different technical snags. These technical snags are manifested due to:

• Large File Sizes of Excel.
• Version incompatibility issue.
• Large images and other Excel file properties.
• Sophistication in Windows Server.
• File Sharing.

Once the reason of the error is clear, there comes the time to sort the issue from the root. It requires simple approach of third-party Excel Repair software. You can try free version of this tool be downloading below link to fix any corruption issue of Excel file.

However, the other approaches also include:

• Copying entire content to the new file.
• Saving under new version of Excel.
• Rename the existing file.

Even though the other approaches are convenient but they fail to provide satisfactory result. Thus, a professional approach is required to be implemented to provide effective solution.

Simply install the hotfix package. However, if you are doing it your own, then any loss will also be owned by you. There could be serious problems if any registry goes wrong. Thus, taking complete back-up of the system is highly recommended.

The installation of hotfix package can be done as follows:

1. Click Start -> Run. Type regedit in the Open box and click OK.
2. Locate and select the following registry:
   HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options
3. Point to New, and then click DWORD (32-bit) value on the Edit menu.
4. Type FullLoadImagesOnFileLoad followed by ENTER.
5. From Details, right click FullLoadImagesOnFileLoad and click Modify.
6. Type 1 in Value Data Box followed by OK.
7. Exit Registry Editor.

It may seem easier but may cost you more than you deserve if registry update goes wrong.

The third-party Excel Repair tool is developed for the users who feel inconvenience in repairing the Excel error on their own. The tool supports all versions of MS Office like 2016, 2013, 2010, 2007. To evaluate the proficiency of the tool just try them for once.

Consider the following scenario: You are working on a project to automate Microsoft Office. Therefore, you have opened the Microsoft Visual Basic for Applications editor. An Excel worksheet is open as well, which contains a think-cell Excel data link (see Excel data links).

You delete the Excel worksheet where think-cell's Excel data link resides. Excel may show an error message: "Object required".

If you try to save the Excel file, Excel shows an error message:
"Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel."

When you click Continue, the repair fails.

Excel 2007 or 2010: Excel crashes if you try to insert a new Excel worksheet instead of trying to save the file.

Cause

The problem is caused by a bug in Excel. We have filed a case with Microsoft. If your company has a Microsoft Office Support contract and you want to contact Microsoft to ask for a fix, you may refer to Microsoft case number 114072911657591. The error can be reproduced without think-cell.

Please perform the following steps:

1. Start Excel with a new empty file.
2. Enter 100 in cells A1 and A2 on the first worksheet, Sheet1.
3. Select the cells A1:A2 on Sheet1 and press Ctrl + C to copy.
4. (Only if you try to reproduce with Excel 2013 or later: Insert a second worksheet. Older Excel versions have three default worksheets, so this is not required).
5. Press Alt + F11 to open the Microsoft Visual Basic for Applications editor window, and leave it open.
6. Start Word with a new empty file.
7. In Word, go to Home → Paste → Paste Special → Paste Link: Microsoft Excel Worksheet Object and click OK.
8. In Excel, right-click the Sheet1 tab and click Delete.

9. Try to save the Excel file. Excel shows an error message:
   "Errors were detected while saving [file name]. Microsoft Excel may be able to save the file by removing or repairing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel."

   When you click Continue, the repair fails.

   Excel 2007 or 2010: Excel crashes if you try to insert a new Excel worksheet instead of trying to save the file.

Solution

If you encounter this error, you can save your data in a new Excel document or discard the changes and repair the original document:

Save your data in a new Excel document

To save changes you made to your document, copy the worksheets you changed to a new Excel document and save it.

Repair your Excel document to avoid this error in the future

You can repair your Excel document by deleting any Visual Basic for Applications (VBA) projects from your document. However, simply deleting them in the Visual Basic editor is not sufficient. Please use the following procedure:

1. Create a backup of your document.
2. Download and run the free Structured Storage Viewer.
3. Open your document in the Structured Storage Viewer.
4. In the tree view of your document, select _VBA_PROJECT_CUR and press Del to delete it.
5. Confirm deletion and close the Structured Storage Viewer.
6. Open the document in Excel.
7. There will be a dialog box Microsoft Visual Basic → File not found . Hit OK.
8. There will be another dialog box Repairs, with Lost Visual Basic project listed. Hit Close.
9. Save your document.

You should now be able to delete the worksheet with think-cell links and then save the document.