Fix Visual Basic Errors When Opening an Excel 2016 Workbook
Question details
The user needs to diagnose Visual Basic or formula-related errors that appear when opening a specific Excel 2016 workbook.

- Product
- Microsoft Excel 2016
- Device & OS
- not provided
- Scenario
- Opening one workbook produces errors, while reinstalling Office has not resolved the issue.
- Observed behavior
- Excel displays Visual Basic or formula-related errors when the affected workbook opens.
Check whether other workbooks open normally and note the exact error message. Before sharing the affected file, make sure it contains no confidential information and that you trust the recipient.
Share a Non-Confidential Workbook Copy for Diagnosis
Use this method to help someone determine whether the errors come from the workbook's content.
Create a copy of the affected workbook and check its sheets, formulas, and other content for confidential information before sharing it.
Sign in to OneDrive, select Upload, and choose the non-confidential workbook copy.
Select the uploaded file, choose Share, and send a link to a trusted person who can diagnose it. Choose restricted link permissions when available.
Include the exact error message, when it appears, and whether other workbooks open normally with your shared link.

Try Open and Repair in Excel 2016
Use Excel's repair feature if the workbook may be damaged.
Open Excel Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Microsoft Office formats, making it easier to move existing files between applications. It does not repair Excel-specific Visual Basic errors, and macro support may differ.

Frequently Asked Questions
Why does the error appear in only one workbook?
The workbook may contain damaged content, a problematic formula, or Visual Basic code that triggers the error. Try opening other workbooks and share a non-confidential copy of the affected file for diagnosis.
How do I share the workbook through OneDrive?
In OneDrive, select Upload and choose a non-confidential copy of the file. Then select the uploaded file, choose Share, and send a restricted link to a trusted recipient.
Where is Open and Repair in Excel 2016?
Go to File > Open > Browse, select the workbook, and choose Open and Repair from the arrow next to the Open button.
Will reinstalling Office repair the workbook?
Reinstalling Office does not necessarily repair a damaged workbook or correct its formulas or Visual Basic code. If the error occurs only with one file, investigate the workbook itself.




