Why does it take so long to open files with Excel 2007 or later?
When you double-click an Excel file, Excel 2007 takes a seemingly long period of time to open the file (up to a minute).
The problem may be caused by the properties associated with the Excel file type that tells Windows and Excel how to open the file. This solution corrects a known issue with the Open and Edit actions and also has you disable DDE (dynamic data exchange) as the means to open the file. Both of these changes will result greater responsiveness when you open an Excel file. This process would need to be performed for each Excel file extension:
- XLS – Excel 97-2003 Workbook
- XLT – Excel 97-2003 Template
- XLSX – Excel 2007 Workbook
- XLSM – Excel 2007 Macro-Enabled Workbook
- XLTX – Excel 2007 Template
Note that the file extensions for Excel 97-2003 are supported for Excel 2007 and would also need to be addressed even though you are using Excel 2007.
- Click Control Panel on the Windows Start menu. If your start menu uses the Windows classic style, you will need to first click the Settings menu on the Start menu in order to click Control Panel.
- Double-click Folder Options
- Click File Types
- For each of the above file extensions, follow these steps:
- Scroll down the list and locate the Excel file extension.
- Click Advanced
- In the Actions list, select Open
- Click Edit
- In the Application used to perform action box, you will see something like the following:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e
- If you see %1 at the end of the above text, place double-quotes around the "%1". If you do not see %1 at the end of the text, add it. The result should look like this:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"
- Clear the Use DDE checkbox.
- Click OK
- Click OK to dismiss the Edit File Type window
- Click Close when finished