When I try to open Excel files, there is a noticeable delay. Kindly look into this issue and resolve it

When you experience a noticeable delay while opening Excel files, it may be due to several factors, including excessive formatting in the workbook. Excel Online has a timeout limit of 30 seconds for opening workbooks, and if a workbook takes longer than this, it can trigger delays. Common issues that can cause delays include:

1. Excessive Cell Styles: Too many cell styles, shapes, or formatting can significantly slow down the opening process. You can check the number of styles in your workbook by going to the Home tab and clicking the down arrow in the Styles group.
2. Complex Workbook Elements: Elements such as worksheet protection, defined names, and complex formulas (like VLOOKUP) can also contribute to the delay.

To resolve this issue, you can use the Inquire add-in to clean up excess or duplicate formatting in your workbook. Here’s how to enable the Inquire add-in:

1. Go to File > Options > Add-ins.
2. Select COM Add-ins from the Manage menu and click Go.
3. Ensure the check box next to Inquire is selected, then click OK.

Once the Inquire add-in is loaded, you can use it to clean excess cell formatting, which should help reduce the opening time for your Excel files.

References:

• "Request Was Taking Too Long" when you open a workbook in Excel Online
• "Request Was Taking Too Long" when you open a workbook in Excel Online