Excel 2021 Opens 2nd / Subsequent File from Explorer Slowly

Hi Dan_WangDanWang,

o answer your questions:

1. Microsoft has not yet announced whether the fix for the slow opening of second and subsequent Excel files from Explorer will be included in future Excel products. However, they have acknowledged the issue and are investigating a fix.
2. The registry value is empty by default because it is not necessary for most users. Setting the registry value can speed up the opening of second and subsequent Excel files from Explorer, but it is not guaranteed to work for all users and may cause Excel instability in some cases.

Recommendation:

If you are experiencing the slow opening of second and subsequent Excel files from Explorer, you can try setting the registry value. However, proceed with caution and back up your registry before making any changes.

To set the registry value, follow these steps:

1. Open the Registry Editor.
2. Navigate to the following key:

HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\CurrentVersion\Options

1. Right-click on the Options key and select New > DWORD Value.
2. Name the new value DisableDynamicDataExchange and press Enter.
3. Double-click on the DisableDynamicDataExchange value and enter a value of 1 in the Value data field.
4. Click OK to close the Registry Editor.
5. Restart Excel.

If you experience any problems after setting the registry value, you can reset it to its default value by following the steps above and entering a value of 0 in the Value data field.