[Fixed] Excel Crashing When Opening Files from Mapped Drive

Why Excel Crashes from Mapped or Network Drive?

Well, Excel closes when opening a file from a network drive due to network latency, an untrusted location, and a temporary file failure. Here's an explanation of these:

• Network Latency: When you are working, Excel constantly communicates with the network drive as it opens and saves files. If the network is slow, Excel may not receive data in a timely manner, leading to application freezes and crashes.
• Not a Trusted Location: Excel has built-in security features that treat files from various network locations differently from those on your device. If the mapped network drive isn't added as a trusted file, Excel blocks access, leading to Excel crashes when opening file from shared drive.
• Temporary File Failure: When you open a workbook in Excel, it creates temporary files to support features like AutoRecover. If it's unable to create or update these files, the workbook may not open, resulting in unexpected closure.

You may also like:

[Fixed] Excel Keeps Crashing When Opening File/Saving/Copying and Pasting

How to Fix Excel Crashing When Opening Files from a Mapped Drive?

To fix Excel hangs when opening file from network drive, you should add the network drive to trusted locations, update Windows and drivers, and disable firewalls. Here's how these work:

Fix 1: Add the Network to Trusted Locations (Most Common Solution)

You should add the network to the Trusted locations by making changes in the Trust Center settings. For that, the steps are:

• Open Excel and then click on the File option.

• From the navigation panel, tap Options.

• Click on Trust Center > Trust Center S ettings.

  

• In the Trust Center window, choose Trusted Locations from the left menu.

• Tick the Allow the Trusted Locations on My Network box on the bottom and then click Add New Locations.

  

• Select Browse > "Global Share (R:) > OK.

• Go back to the Trusted Location window and check that the subfolders of this Location are also Trusted.

• Click OK.

Fix 2: Update Office, Windows, and Drivers

It's important to update your Microsoft Office, Windows, and drivers on time to ensure you have all the latest features and security updates. Doing so also fixes all the bugs, so you can use all applications without any bottlenecks. To update Microsoft Office on your Windows, follow these steps:

• Open any Office application, whether it's Excel or PowerPoint.

• Click File in the top left corner.

• Choose Account or Office Account from the sidebar.

• Right under Product Information, tap Update Now Options.

  

• Select View Updates or Check for Updates. If there's one available, start it.

Fix 3: Disable COM Add-ins

COM add-ins (Component Object Model) are software programs that plug into Microsoft Office applications to enhance their functionality. Multiple add-ins often slow down apps and cause lagging, so it's best to disable them using these steps:

• Open the Outlook Desktop app.

• Click File in the top left corner and select Options.

• In the Options window, click Add-ins from the left pane.

• At the bottom of the Window, you'll see Manage > COM Add-ins.

• Click Go. You will get a list of installed COM Add-ins.

  

• Uncheck the box next to these add-ins.

• Click OK to save changes.

  

Fix 4: Turn On Antivirus and Firewall Tweaks

Keeping your antivirus and firewall up to date is essential for layered defense against macro viruses, data theft, unauthorized network access, and Excel crashing when opening files. Here are the steps that you can follow to turn it on:

• Open the Windows Security app on your PC and select Firewall & Network Connections. You'll see which networks you are connected to.

• Select a network profile: Domain, Private, or Public.

• Switch on Microsoft Defender Firewall.

  

• For further protection, under the Incoming Connections section, tick the box labeled "Blocks all Incoming Connections".

Fix 5: Disable DDE in the Excel Registry Open Command

It's also suggested to disable Dynamic Data Exchange (DDE) in the Excel Registry to prevent malware attacks and security vulnerabilities. Your documents will then work smoothly, without any crashes or sudden closing issues. Let's look at the steps to disable DDE:

• Press Windows + R to open the Run dialog box.

• Type regedit and press Enter.

• In the Registry Editor, go to the key HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open.

  

• Click Open the key and check if it has a subkey named ddeexec.

• Right-click the subkey and select Rename.

• Rename it to something like ddeexec_backup. This ensures you disable the DDE while having it as a backup to restore when needed.

• Close the Registry Editor.

You may also like:

9 Proven Ways to Fix Microsoft Excel Not Responding

⚡ Advanced Way: If Excel Still Crashing When Opening from Mapped Driver?

If Excel crashing when open files from mapped drive happens again, it may be because the files are corrupted or damaged. To fix this, you can give 4DDiG File Repair a shot. Whether the file contains blank content or is not displayed, this tool can easily repair it.

It can recover fonts, images, headers, and links from the damaged file, as well as tables, pivot tables, and charts, so your data doesn't get lost. The best part is that it supports Excel formats such as .xlsx and .xlsm, as well as versions such as 2019, 2016, 2013, and earlier.

Here's how you can use it:

• Open 4DDiG File Repair and select File Repair from the left menu. Click Add Files to upload one or multiple corrupted Excel files.

  

• Once you have added all the files, click on Repair All.

  

• Let the tool do its work, and once done, preview all files to ensure everything is clear.

  

• Finally, click Save or Save All to store the repaired files on your device.

Conclusion

Well, Excel Crashing When Open Files from mapped drive can be a stressful experience, especially if you are working on important official documents. However, don't stress out and try 4DDiG File Repair to avoid the hassle. It's easy to use, secure, and does the job in seconds!