Lỗi microsoft excel has stopped working

Workable SolutionsStep-by-step Troubleshooting
Fix 1. Open Excel in Safe mode Type excel.exe pháo /safe in Run box lớn open the Excel in safe mode. Check if the software still crashes...

You watching: Lỗi microsoft excel has stopped working

Full steps
Fix 2. Disable Add-ins Opening Excel in safe mode, clichồng "File" > "Options" > "Add-ins". Select "COM Add-ins", và click "Go"...Full steps
Fix 3. Check antivirus/conflictsTry to over antivi khuẩn as well as the running applications lớn see if the issue is removed...Full steps
Fix 4. Change mặc định printerGo lớn the Control Panel > cliông chồng on "Devices & Printers" > mix "Microsoft XPS Document Writer"...Full steps
Fix 5. Repair Microsoft OfficeGo lớn the "Control panel" > choose "Programs & Features" > click "Change"...Full steps
Fix 6. Recompile MacrosOpen Excel & cliông chồng on "Developer" > "Visual Basic". Go to "Tools" > "Options" > "General"...Full steps
Fix 7. Keep Excel updatedOpen any Office ứng dụng. Go to "File" > "Account".Under Product Information, choose "Update Options"...Full steps

Microsoft Excel Has Stopped Working When Saving

"Last night, when I finished working on a complex workbook and tried khổng lồ save sầu it, Windows reported that "Microsoft Excel has stopped working" và didn"t allow any operation on the document. What"s worse was that I hadn’t saved my document yet. How could I solve this issue and recover my unsaved file? I"m using Microsoft Excel 2016."

Thanks lớn Microsoft Excel, we can giảm giá with almost all the data relevant work, whether simple or complex data processing. Most of the time, Microsoft Excel runs smoothly & flawlessly. However, sometimes, loathsome & unspecific errors can make it down and stop work properly. On this page, we will focus on Microsoft Excel has stopped working when saving and discuss the solutions.

*

Part 1. 7 Useful Solutions lớn Microsoft Excel Has Stopped Working

Microsoft Excel has stopped working when saving may result from many matters, lượt thích lots of details & contents contained in Excel, the file is generated by a third-buổi tiệc nhỏ application, add-ins interference, outdated Excel version, and more. However, whatever the reason might be, learn how to get rid of this error now.

1. Open MS Excel in Safe Mode 

Press Windows+ R khổng lồ open the Run option. Type excel.exe /safe and cliông xã "OK" to open the MS Excel in the safe mode. You can see if the software still crashes. This will help if an add-in or another program is causing Excel lớn stop working.

*

2. Disable Problematic Add-ins

Step 1. Opening Excel in safe mode, cliông chồng "File" > "Options" > "Add-ins". Select "COM Add-ins", và cliông xã "Go".

Step 2. You can try to disable the add-ins one by one and check if the problem has been resolved. If you have sầu added an add-in recently, you can try to lớn remove it first, and see if Excel works correctly after that.

*

3. Chechồng for Antivirut & Other Program Conflicts

The antivi khuẩn or other program conflicts can cause the Excel has stopped working error. So here, try to lớn over antivirut as well as the running applications to lớn see if the issue is removed. Besides, it is recommended that you check whether your anti-virus software is up to lớn date or not.

4. Change Default Printer

When you open an Excel document, it attempts lớn communicate with the printer. If that communication fails, Excel might crash và stop working. In this case, you can troubleshoot by changing the default printer.

Go to lớn the Control Panel > clichồng on "Devices và Printers" > mix "Microsoft XPS Document Writer" as the mặc định printer. Once done, try to open Excel again, and your problem may be resolved.

*

5. Repair Microsoft Office

Step 1. Go to the "Control panel" > choose "Programs & Features". Find Microsoft Office in the list, right-click it và clichồng the "Change" button.

See more: Rasterize Layer Là Gì ? Rasterize Layer Là Gì? On Fpt Arena

Step 2. When you click on the Change option, then an office window appears on the screen. Select "Quick Repair" > cliông xã on the "Repair" button. Wait for the process to lớn finish.

*

6. Recompile Macros

You can kiểm tra for the macros as some users have sầu reported that problematic macros can make Excel stop working.

If the Developer tool is not in the thực đơn bar, you can add it khổng lồ the menu bar as follows.

Start Excel > click on "File" > "Options" > "Customize Ribbon" > check "Developer" in the Main Tabs các mục.

*

Step 1. Launch Excel and clichồng on "Developer" > "Visual Basic". Go to lớn "Tools" > "Options".

Step 2. In the Options window, switch to the "General" tab, clear "Compile on Demand".

*

Step 3. In the "Project" navigation pane, right-cliông chồng "Module" and select ‘Insert’ to lớn insert a new module. Then, save your spreadsheet & cthua kém Excel. Then, next time you use macros, you shouldn"t encounter the Microsoft Excel stops working error.

7. Keep Microsoft Excel Updated 

If your Microsoft Office installation is outdated, you’ll probably meet applications working issues, like Excel stops working here, Word not responding, Word keeps crashing when saving, etc. You can possibly resolve this issue by installing the latest MS Office updates.

Step 1. mở cửa any Office app, Word or Excel. Go to lớn "File" > "Account".

Step 2. Under Product Information, choose "Update Options" > "Update Now".

*

Conclusions

We"ve sầu covered all the comtháng solutions to Excel stopped working error in this article, and you can try them one by one khổng lồ resolve sầu the problem. But none of these measures is 100% effective. If you thua your Excel unsaved unluckily, you can resort to the AutoRecovery feature to get bachồng the lost Excel tệp tin.

Step 1. Start Microsoft Excel application, cliông chồng "File" > "Recent".

Step 2. Click "Recover Unsaved Workbooks" & choose the unsaved Excel.

Step 3. Clichồng the "Open" button. Then cliông chồng "Save As" and save sầu this document into lớn any other safe place.

*

Part 2. Extra Guide: How to Recover Deleted Excel Files

Other than losing an unsaved Excel document, another hot topic is accidentally deleting saved documents. You may thảm bại the saved Excel tệp tin by accidental deletion, hard drive sầu formatting, emptying recycle bin, partition loss, virus attachồng, and more. Under this circumstance, you need a file recovery tool to lớn help you restore lost files.

giaidap.info Data Recovery Wizard is a world-wild trusted data recovery program that enables you to restore lost documents, graphics, videos, audio, gmail, và other files.

See more: Prepositional Phrase Là Gì, Cụm Giới Từ Trong Tiếng Anh

Now, download this capable tool khổng lồ recover deleted Excel file within only three steps. It even allows you khổng lồ recover files from emptied recycle bin.


Chuyên mục: Chia sẻ