Slow Opening Excel 2003 Files in Excel 2007 (Updated)
by m3Rlin on Jun.12, 2007, under Computers, Microsoft, Software, Windows
When opening Microsoft Excel 2003 files in Microsoft Office Excel 2007 without having Excel 2007 already running you may find that files that a long time to open (20-60 seconds) while Excel 2007 or even Microsoft Office Word 2007, PowerPoint 2007 files take only a portion of that time to load.
The solution to this problem is easy and does not require any additional software other than the standard Microsoft Windows Explorer.
- Open Windows Explorer (explorer.exe)
- Select Tools | Folder Options from the menu
- Go to the File Types tab.
- Select list item XLS (Microsoft Office Excel 97-2003 Worksheet) and click on Advanced.
If the “Appl ication used to perform action:” field the default value should be “C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE” /e” . Change this to “C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE” /e “%1″ . Remember to enclose the full excel.exe path and %1 in parenthesis. Since Windows 95 this is a way to escape spaces in file names; %1 will return the file name of that file that is being opened by double-clicking.You can uncheck “U se DDE” but Microsoft Office Excel 2007 will bring it back to what you see above when you next open it.
- Just confirm (hit “OK” ) on all the Microsoft Windows Explorer dialogs and next time you open a Excel 2003 file in Excel 2007 without having it already running you won’t have to wait!
- If the above listed steps don’t fix the problem, simply add the Lookup Wizard add-in in Excel. Some readers have reported that solved the problem for them! To install it click the Office Button, Excel Options, Add-Ins, and then click Manage Excel Add-ins | Go on the bottom of the window, select Lookup Wizard and click OK!
56 Comments for this entry
Leave a Reply
Custom Search
April 8th, 2009 on 11:27 PM
excellent solution and it worked successfully.
April 27th, 2009 on 5:09 PM
This fix did not work for me. Excel documents still takes 60 seconds to launch from a double-click. Any other ideas?
May 6th, 2009 on 9:21 AM
I did what you said and the first time I opened an Excel 2003 xls file it displayed immediately. But thereafter when I opend one it is now back to taking 20-60 seconds. I can shortcut the time by clicking the Windows icon in the upper left hand corner. My default value had the /e but also had /n? Any further ideas?
Thoss
May 11th, 2009 on 6:04 AM
I have the same problem with 2007 Excel and Word data files opening slow…while the main app opens just fine. I am running Vista Business 64, and I do NOT have a file types tab on my folder options. HELP !!!
May 12th, 2009 on 9:06 AM
I used the “%1″ and it didn’t work at first. It only worked when I finally unchecked the DDE box.
May 29th, 2009 on 11:46 AM
The /n is for the New. You need to select the Open before you edit. It it has work twice for me so far. We as a company are upgrading to Office 07 and this has come up. This fix is working for me
Thanks