'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Opening Additional Workbooks Slowly from File Explorer
Question details
The user experiences a significant delay when double-clicking a second Excel workbook in Windows File Explorer while the application is already running.
- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Opening an additional spreadsheet directly from File Explorer when an instance of Excel is already active.
- Observed behavior
- The selected workbook takes an abnormally long time to load, even though opening the exact same file from within Excel's own File menu happens quickly.
Before making any changes to the Windows Registry, ensure you create a backup of your current registry settings by exporting them, as incorrect modifications can cause system instability.
Update Dynamic Data Exchange (DDE) Registry Settings
Modify the DDE execution parameters in the Windows Registry to restore normal file opening speeds for Excel files.
This delay is typically caused by outdated or corrupted Dynamic Data Exchange (DDE) information in the Windows Registry. By updating the DDE execution commands for both older and newer Excel file formats, you can resolve the handoff delay between File Explorer and Excel.
Press the Windows Key + R on your keyboard, type 'regedit' in the Run dialog box, and press Enter. Click 'Yes' if prompted by User Account Control.
In the left pane, navigate to HKEY_CLASSES_ROOT \ Excel.Sheet.8 \ shell \ Open \ ddeexec to fix the behavior for older .xls files.
Double-click the '(Default)' string in the right pane. Change the Value data to [open("%1" /ou "%u")] and click OK.
Next, navigate to HKEY_CLASSES_ROOT \ Excel.Sheet.12 \ shell \ Open \ ddeexec to fix the behavior for modern .xlsx files.
Double-click the '(Default)' string here as well, set its Value data to [open("%1" /ou "%u")], click OK, and then restart your computer for the changes to take effect.
Disable DDE Settings within Excel
Adjusting Excel's internal advanced settings to bypass DDE completely, which is an alternative way to resolve launch delays.
Experience Lightning-Fast File Opening with WPS Office
Tired of performance lag and dealing with registry errors? WPS Office offers a lightweight, highly compatible alternative to Microsoft Excel that opens files instantly from File Explorer without DDE complications.
- 1. Download and Install: Visit the official WPS website, download the free installation package, and complete the quick setup.
- 2. Set as Default Application: Right-click any Excel file in File Explorer, select 'Open with', choose WPS Spreadsheet, and check 'Always use this app'.
- 3. Enjoy Instant Access: Double-click your workbooks to experience fast, delay-free file launching every time.
Frequently Asked Questions
Why does Excel open files quickly from the File menu but slowly from File Explorer?
Opening a file directly from Excel's 'File' menu handles the process internally within the application. Opening from File Explorer relies on Dynamic Data Exchange (DDE) protocols. If the DDE registry keys are corrupted or outdated, Windows struggles to hand off the file to the already-open Excel instance, causing a noticeable delay.
What is the difference between Excel.Sheet.8 and Excel.Sheet.12 in the registry?
In the Windows Registry, Excel.Sheet.8 controls the system behavior and file associations for older Excel 97-2003 formats (which use the .xls extension), while Excel.Sheet.12 is responsible for handling modern Excel formats introduced with Office 2007 (which use the .xlsx extension).
Is it safe to change the DDE registry settings?
Yes, it is generally safe if you follow exact instructions and only modify the specific keys mentioned. However, because the registry is a critical system component, modifying it always carries some risk. It is highly recommended to back up your registry before making any changes.
