Stop Excel from Accessing a VPN-Only File at Startup
Question details
Identify why Excel accesses a VPN-only file at startup and prevent the resulting delay.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Excel starts while a referenced file is unavailable because it can only be reached through a VPN.
- Observed behavior
- Excel attempts to access the file during startup and launches slowly.
Note the file name or network path Excel is trying to access and whether the delay occurs with every launch or only when opening a particular workbook. Menu names and available diagnostic options can vary by Excel version and operating system.
Check Excel startup folders and add-ins
Use this method when the delay occurs as Excel launches, even before you open a specific workbook.
In Excel, open File > Options > Advanced. Under General, check the path in “At startup, open all files in.” Remove or update the path if it points to the unavailable location, then select OK.
Check the Excel XLSTART startup folder for files or shortcuts that reference the VPN location. On Windows, press Win+R, enter %appdata%\Microsoft\Excel\XLSTART, and inspect the folder. Excel may also use an installation-specific XLSTART folder; check its location under File > Options > Trust Center > Trust Center Settings > Trusted Locations.
Look for a workbook such as PERSONAL.XLSB or another file in XLSTART that may contain a reference or macro accessing the VPN path. Move a suspected file temporarily out of the startup folder and restart Excel to test it; moving PERSONAL.XLSB also makes its personal macros unavailable until you restore it.
Open File > Options > Add-ins. In the Manage list, select Excel Add-ins and click Go, then temporarily clear suspected add-ins. Repeat for COM Add-ins if available, restarting Excel after each change to identify the cause.
Once you identify the startup file or add-in, update its network path or remove the unneeded reference using the workbook or add-in's settings. Restore any files or add-ins that were not responsible.

Use Excel Safe Mode to narrow down the cause
On Windows, use Safe Mode to check whether a startup component is contributing to the delay.
Review external links in the affected workbook
Use this method when the delay occurs only when you open a particular workbook.
Open and edit spreadsheets with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing existing spreadsheets. It supports common Excel formats for an easier transition, although it does not repair Excel's startup settings.

Frequently Asked Questions
Why does Excel try to open a file when it starts?
A startup folder, add-in, personal macro workbook, or workbook link may reference the file. Check File > Options > Advanced for an alternate startup folder, then inspect XLSTART and File > Options > Add-ins.
How can I tell if an add-in is causing the delay?
On Windows, launch Excel with Win+R > excel /safe and compare the startup time. If it improves, use File > Options > Add-ins to disable suspected Excel or COM add-ins one at a time and restart Excel after each change.
Where is the XLSTART folder on Windows?
Press Win+R and enter %appdata%\Microsoft\Excel\XLSTART. Excel may also use an installation-specific XLSTART folder; check File > Options > Trust Center > Trust Center Settings > Trusted Locations for its path.
What if the delay happens only with one workbook?
Open that workbook and check Data > Workbook Links, or Data > Edit Links in some versions, for a reference to the VPN-only file. Update the source or remove the link if it is no longer needed.
Will moving PERSONAL.XLSB stop my personal macros from loading?
Yes. If you temporarily move PERSONAL.XLSB out of XLSTART to test startup, its macros will not be available until you restore the file and restart Excel.




