The third-party products that this article discusses are manufactured by companies that are independent of Microsoft.
You receive a "Too many different cell formats" error message in Excel. Excel add-In to reset the last worksheet cell. Locate and reset the last cell on a worksheet. In addition to cleaning up excess or duplicate formatting, consider tidying up your workbook by using the following resources: Open the Inquire tab, and then select Clean Excess Cell Formatting. You should now see the Inquire add-in loaded in the workbook ribbon. On the Manage menu at the bottom of the page, select COM Add-ins, and then select Go.Īfter the COM Add-ins window opens, make sure that the check box next to Inquire is selected, and then click OK. To load the Inquire add-in for Excel, follow these steps: To have Excel to clear excess or duplicate formatting, use the Inquire add-in. These excessive cell styles, mixed with the many other elements in this workbook (such as sheet protection, defined names, and VLOOKUP formulas), cause the loading process to exceed the 30-second time-out duration that is set by Excel Online. Here are examples of duplicate or excessive formatting.Įxample 1: This example has 3,284 duplicate formatting items.Įxample 2: This example has 11,837 excessive formatting items. In a new workbook, your list of styles should resemble the following list. To view existing styles in a workbook, locate Home tab > Styles > Down arrow. To see the cell styles for an Excel workbook, locate the Home tab, and then click the Down arrow in the lower-right corner of the Styles group. Styles: When a workbook has too many cell styles, shapes, or formatting, it can cause Excel Online to take many times longer to open a file than usual. 
Defined names: You probably can't remove defined names because those may be necessary for data validation or an Excel Web Access web part that uses those named items.Therefore, this most likely isn't a viable solution. VLOOKUP formulas: If you remove VLOOKUP formulas, you may break the calculation chain of your workbook.
Worksheet protection: Removing the worksheet protection probably isn't the best option because this method prevents users from being able to edit certain cells that most likely contain formulas. 
The following are some common problem areas to consider when you troubleshoot this issue: This is because all the steps that are mentioned in the referenced post relate to tidying up a file to make it consume fewer resources, and open and run more quickly.Ī very complex workbook that contains many workbook elements may take a long time to open. We can use the same method to avoid the "Request Was Taking Too Long" errors in Excel Online.
#MAC EXCEL 2013 SOME FILE SLOW TO OPEN HOW TO#
The Excel client team has written an excellent article about how to clean up a workbook so that it uses less memory. This issue occurs if the workbook takes longer than 30 seconds to open in Excel Online.Īlthough there can be many reasons why a file is slow to open, excess formatting is a very typical cause. When you open a specific workbook in Excel Online, you receive a "Request Was Taking Too Long" error message. This article was written by Tom Schauer, Technical Specialist.
0 kommentar(er)
