File Corruption & Recovery

Fix Visual Basic Errors When Opening an Excel 2016 Workbook

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

The user needs to diagnose Visual Basic or formula-related errors that appear when opening a specific Excel 2016 workbook.

Fix Visual Basic Errors When Opening an 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.
Before you start

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.

Solution 1Recommended

Share a Non-Confidential Workbook Copy for Diagnosis

Use this method to help someone determine whether the errors come from the workbook's content.

1
Prepare a safe copy

Create a copy of the affected workbook and check its sheets, formulas, and other content for confidential information before sharing it.

2
Upload to OneDrive

Sign in to OneDrive, select Upload, and choose the non-confidential workbook copy.

3
Share the file

Select the uploaded file, choose Share, and send a link to a trusted person who can diagnose it. Choose restricted link permissions when available.

4
Describe the error

Include the exact error message, when it appears, and whether other workbooks open normally with your shared link.

Share a Non-Confidential Workbook Copy for Diagnosis
Avoid sharing sensitive data: Do not upload or share the workbook if it contains information you are not permitted to disclose.
Free Microsoft Office alternative

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.

Open and review spreadsheet content in WPS SpreadsheetsCompatible with common Microsoft Excel formats, including XLSX and XLSFamiliar interface for working with existing Office filesFree and lightweight for everyday document tasks
microsoft office alternative - wps office

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.