If an Excel worksheet takes too much time to open, what can we do?
I suggest the following tactics Reboot yourputer and try opening the file again. Launch Excel in Safe mode (no Add-ins or VBA code) by using the mand line option. You do this with the Windows SystemRun menu item by typing CProgram Files (x86)Microsoft Note that your copy of Excel may be located in a different place so verify the path in Windows Explorer before you try it. Once Excel launches then use its FileOpen menu item to open your file. If the file opens quickly when you do this your file may have slow running VBA code. If you do get your file open the next step is to figure out why it takes so long. Do the scrollbars extend far beyond your data? If so delete the blank rows and columns below and to the right of your data. Save the file. Close it. Reopen the file. Do you use many thousands of volatile functions in worksheet formulas? These include INDIRECT RAND TODAY NOW OFFSET and INFO. Volatile formulas recalculate every time any change is made to any open workbook. There are workarounds available to replace each of these volatile functions with non-volatile onesjust ask. Does your file have thousands of cells using Conditional Formatting? This will slow Excel down significantly so consider removing the Conditional Formatting with the HomeConditional FormattingClear RulesClear Rules from Entire Sheet menu item.