How to Work on Large Excel Files Without Crashing (5-Step Guide) - Qiling  

How to Work on Large Excel Files Without Crashing (5-Step Guide)


How's your experience in working on a large Excel file in Windows 10, like ~10MB? In fact, accountants for example, are producing Excel files with much bigger size than 10MB. Some people noticed that large files are likely to cause a crash in Excel. Is the file size responsible for the crash? 

As a matter of fact, big file size is not the real culprit for the Excel crashing issue. It's said that unstable, crashing, or freezing workbooks only tend to happen when your spreadsheets have grown to at least 20MB in size, given how much processing power modern computers have. Hence, you should consider other factors that crash Excel when the file you're working on is far less than 20MB in size.

Tags:

Excel crashingExcel corruptedMacro-enabled ExcelExcel closing automatically

Why Large Excel Files Crash

Except for the fact that the excel file is really large over 20MB, chances are that there are other factors that make your Excel unsteady to use. The factors are basically as follows:

How to Make Large Excel Files Work Faster Without Crash

Important
A large excel file usually contains hundreds of rows of critical data with many styles and formulas in it, so you must take good care of the workbook by making a real-time backup, in case one day unexpected data loss happens due to the Excel crash, not responding or stop working suddenly before you can click Save. We suggest everyone turn on auto save in Excel, to save the workbook every 1~5 minutes.

Next, we're going to troubleshoot a slow workbook upon opening or editing in Excel around the discussed three factors. No matter it's a small or big Excel file since it causes a crashing issue in Excel, the given solutions in each section should help.

Step 1. Remove Excessive Formatting

Formatting cells on your worksheet can make the right information easy to see at a glance, but formatting cells that aren't being used (especially entire rows and columns) can cause your workbook's file size to grow quickly. Microsoft has its own add-on called Clean Excess Cell Formatting, which is available on Excel's Inquire tab in Microsoft Office 365 and Office Professional Plus 2013. If you don't see the Inquire tab in Excel, do the following to enable the Inquire add-in:

clean excess cell formatting 1

To remove the excess formatting in the current worksheet, do the following:

clean excess cell formatting 2

Step 2. Remove Unused Styles

Too many different styles on an Excel workbook are likely to cause a specific error of "Too many different cell formats", and the alongside symptom is a constant crash in Excel. Hence, you should avoid using multiple styles on one worksheet. To clean up workbooks that already contain several styles, you can use one of the following third-party tools suggested by Microsoft.

Step 3. Remove Conditional Formatting

clear conditional formatting

Step 4. Remove Calculations and Formulas

If you've gone through the above three-step check and removable unnecessary cell formatting, styles, and conditional formatting, but still work clumsily on a large Excel workbook, you may need to look at the formulas and calculations in your worksheet. You don't have to check every calculation and fomula you've applied in the file, but those primary ones tend to eat a lot of your computer's resources.

Step 5. Examine the Computer RAM Issue

Last but not the least, if none of the four-step efforts speed up the performance in working on a large Excel file in Windows 10, it may be an issue with your computer's memory. Follow the 10 tips on how to solve high RAM memory usage issue in Windows 10.

How to Repair Corrupted Large Excel Files Efficiently

What if Excel has crashed and corrupted the files? How can you fix damaged Excel in time? Try Qiling file repair. This advanced file repair tool resolves Excel file corruption and restores the .XLS/.XLSX file data. It fixes all types of Excel corruption errors, such as unrecognizable format, unreadable content, Excel runtime error, etc. 

With this file repair tool, you can:

To repair a large Excel file that is inaccessible, follow the below guides. Qiling file repair software also helps you repair corrupted Word, PowerPoint, and PDF documents. 

Step 1. Launch Deep Data Recovery. Select file types and click "Next" to start.

Select file types that you want to recover

Step 2. Then scan disk with corrupted documents. This software enables you to fix damaged Word, Excel, PPT, and PDF files in same steps. 

select the disk with corrupted documents

Step 3. Qiling data recovery and repair tool will scan for all lost and corrupted files. You can find the target files by file type or type the file name in the search box. 

repair corrrupt documents

Step 4. Deep Data Recovery can repair your damaged documents automatically. After file preview, you can click "Recover" to save the repaired Word, Excel, and PDF document files to a safe location.

Related Articles


Is this information helpful?     

What can we do to improve this information? (Optional)
Refresh Please enter the verification code!