Showing posts with label Excel 2007 Very slow to open files. Show all posts
Showing posts with label Excel 2007 Very slow to open files. Show all posts

Saturday, April 12, 2008

Excel 2007 Very slow to open files

If you open an Excel 2007 file by double clicking on a desktop icon, or explorer or from an outlook attachment, the file opens very slowly -- 30 seconds or more...

This is caused by a bad setting in the windows Explorer file type. To fix it in Windows XP try the following:

1. Open Windows Explorer (explorer.exe)
2. Select Tools | Folder Options from the menu
3. Go to the file types tab
4. Select the XLS file type (for Excel 97-2003 files)
5. Click the Advanced button
6. Select Open

7. Click the Edit Button
8. In the Application used to perform action, change the text from:

"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e
to:
"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Note the double quotes around the %1, they are required.

Nolw repeat steps 4-8 for the xlsx file type (Excel 2007 files)