A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
This error indicates Excel or the VBA code is trying to access a resource that cannot be found. Based on the Excel startup and VBA error guidance, use this troubleshooting path:
- Start Excel in Safe Mode
- Press Windows + R.
- Type
excel /safeand press Enter. - If Excel opens, the issue is likely caused by an add-in.
- Disable add-ins
- In Excel, go to File > Options > Add-ins.
- Disable active add-ins, then restart Excel normally.
- If Excel works after that, re-enable add-ins one at a time to identify the one causing the problem.
- Check whether the VBA project is calling a missing file or library
- A “resource cannot be found” error can occur when code refers to a file, DLL, or path that does not exist.
- Verify the file name and full path used by the Automatex license upgrade process.
- Add VBA error checking around the failing statement
- Use
On Error Resume Nextimmediately before the statement that accesses the object or resource. - Then check the
Errobject right after that statement to identify the source of the failure.
- Use
- Repair Office
- Close all Office apps.
- Open Installed apps or Apps and Features.
- Find Microsoft 365 or Office.
- Select Modify.
- Run Quick Repair first.
- If the issue continues, run Online Repair.
- If the VBA code accesses the system registry
- The registration database may be corrupted.
- Run the Setup program for the host application again.
If the error started only when upgrading the Automatex license key, the most likely causes are:
- the VBA macro is calling a missing file or web resource
- an Excel add-in is interfering
- the Office installation needs repair
- Automation error
- File not found (Visual Basic Run-Time Error)
- Error accessing the system registry
- Sorry, EXCEL encountered an error that prevented it from working properly, so EXCEL needs to be closed. Want us to fix it right away? - Microsoft Q&A
- Problem with Excel that prevents if from working - Microsoft Q&A