If multiple sheets adopt the rule, repeat the steps to clear them all.Under Home, click Conditional Formatting.Binary Excel formats (xls, xlsb), workbooks protected by a password, and encrypted workbooks - Remove Styles Add-in.Excel formats (xlsx, xlsm) - XLStyles Tool.To clean up workbooks that already contain several styles, you can use one of the following third-party tools suggested by Microsoft. Hence, you should avoid using multiple styles on one worksheet. 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. After excess formatting has been cleared, click Yes to save changes to the sheets or No to cancel.

Choose whether to clean only the active worksheet or all worksheets.

On the Inquire tab, click Clean Excess Cell Formatting.

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

In the COM Add-Ins box, check Inquire, and then click OK. The Inquire tab should now be visible in the ribbon.Make sure COM Add-ins is selected in the Manage box, and click Go.If you don't see the Inquire tab in Excel, do the following to enable the Inquire add-in: 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. Remove Excessive Formattingįormatting 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. 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. Next, we're going to troubleshoot a slow workbook upon opening or editing in Excel around the discussed three factors. We suggest everyone turn on auto save in Excel, to save the workbook every 1~5 minutes.  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.

Excel 2016 slow to open files