Slow opening Excel files through explorer
You can open Excel and within Excel you can open XLS files, but not with double click on XLS file in windows explore. This is not a solution for the issue above, it’s bypass with some side effects. You have to disable DDE for selected file type and to pass XLS filename to Excel as parameter. Side effect is with each doubleclick on XLS file you will start new instance of Excel but using existing one. This will affect windows ability to group similar buttons on taskbar.
Follow the steps bellow:
- open windows explorer
- go to menu: Tools/Folder Options…
- on tab File Types search for XLS extensions on Registered file types section and click on Advanced (you may have to repeat steps bellow for other Excel file types like CSV…)
- on dialog Edit File Type select Open in Actions, then click Edit… Picture bellow show settings before and after changes you have to made in order to disable DDE.
And you have to add “%1″ at the end of text field Application used to perform action:
More resources on this topic:
Joshua M. Scowcroft:
This is not a permanent solution, upon reboot this is reset to the original values.
3 December 2008, 9:06 pmAndy Wahl:
I tried the “%1″ recommended on other web sites but it did not work. I did the uncheck the DDE box and now files in Explorer load quickley. So my questions is, why has Microsoft not fixed this instead of creating their next OS that will have many new issues?
4 January 2009, 2:51 amBas:
http://www.pcreview.co.uk/forums/thread-1790606.php
Solution
7 January 2009, 4:19 pmSam Cayze:
This setting does not hold, Use DDE will just re-check itself magically
20 July 2009, 8:05 pm