'%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)
How to Fix Excel Crashing When Opening Multiple Network Files Over VPN
Question details
Users experience an application crash when attempting to open a second Excel workbook from a network share while connected to a VPN.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Accessing multiple Excel files from a network drive over a VPN connection while using the Semi-Annual Enterprise Channel of Microsoft 365.
- Observed behavior
- Excel crashes precisely when the second workbook is opened. The crash does not happen when users are physically in the office, when endpoint protection is disabled, or when using the Monthly Enterprise Channel.
Ensure your VPN connection is stable and temporarily verify if disabling your third-party endpoint protection or antivirus software resolves the issue, as security tools often interfere with network file access.
Submit a Support Ticket in the Microsoft 365 Admin Center
Since this crash is specific to the Semi-Annual Enterprise Channel over a VPN, escalating to Microsoft with proper diagnostic logs is the most permanent and policy-compliant path forward.
Microsoft can investigate channel-specific bugs only when provided with detailed system and crash data. This avoids forcing users into an unsupported update channel that may violate your organization's IT policies.
Collect Excel crash logs from the Windows Event Viewer, your exact Office build information, VPN client details, and network setup data.
Log in to the Microsoft 365 Admin Center using your administrator credentials.
Navigate to 'Support' on the left-hand menu and click 'New service request'.
Detail the issue, specifically mentioning the Semi-Annual Enterprise Channel and VPN environment, and attach your collected event logs for Microsoft engineers to review.
Temporarily Switch to the Monthly Enterprise Channel
If immediate access is required for affected users, switching to a channel where the bug is not present can serve as a temporary workaround.
Whitelist Network Locations in Endpoint Protection
Since the issue doesn't occur when endpoint protection is disabled, configuring scanning exceptions for your network shares may prevent the crashes.
Switch to WPS Office for Stable Network File Management
If Microsoft Excel continues to crash over your VPN network due to enterprise channel bugs, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative that handles remote network files smoothly without the bloat of continuous channel updates.
- 1. Download and Install: Visit the official WPS website, download the free installer, and complete the standard installation process.
- 2. Open WPS Spreadsheets: Launch WPS Office and click on 'Spreadsheets' to open the Excel alternative.
- 3. Access VPN Files Safely: Click 'Menu' > 'Open', navigate to your mapped network drive over the VPN, and open your files securely without crashing.
Frequently Asked Questions
Why does Excel only crash when opening a second network file?
The first file might establish a lock or secure session through the VPN. Opening a second file can trigger a conflict with endpoint security scanning or a network timeout bug that is specific to the Semi-Annual Enterprise Channel.
Will changing my Office update channel fix the VPN crash?
Yes, switching from the Semi-Annual to the Monthly Enterprise Channel often bypasses this specific bug. However, you should consult your IT department before doing this, as it may not align with strict corporate update policies.
Can antivirus software cause Excel to crash over VPN?
Yes, active endpoint protection can aggressively scan network traffic. Disabling it temporarily or adding the network share to its whitelist can identify if it is blocking Excel's connection and causing the crash.
How do I collect crash logs for Microsoft Support?
Open the Windows Event Viewer, go to Windows Logs > Application, and look for 'Error' level events related to 'EXCEL.EXE' at the time of the crash. You can right-click and export these logs to attach to your support ticket.
