Error While Opening Excel File That Contains Microsoft VBA Modules

When you try to open a Microsoft Excel workbook that has Microsoft VBA (Visual Basic for Application) modules included, the process may fail and you can not access data. This situation generally occurs due to corruption of XLS file and Excel Recovery is required to handle it.

When you face this situation, you may also encounter the following error message while opening the Excel workbook:

“Unexpected Error (35012)”

Along with this error message, “Disable Macros” dialog box also appears. In this dialog box, you can disable the Excel macros and can fix the error in case it occurs due to macros with invalid or expired digital signatures, suspicious behavior due to macro virus etc.

But you might not be able to open Excel workbook even after disabling the macros. When you click OK button on the error message dialog box, Microsoft Excel closes the workbook but the application remains open.

This entire behavior of Microsoft Excel ultimately results into the inaccessibility of your precious data and cause data loss. To sort out this problem, you need to recognize the root of the problem and perform Excel Repair.

Grounds of the issue

You may encounter this problem in Microsoft Excel workbook if the workbook is corrupted. The error occurs, regardless of the macro code available in the workbook.

An Excel workbook may get corrupted due to a number of reasons that include application malfunction, virus infected macros, unexpected closing of the file and more.

No matter what the cause of this problem is, the final result would be the inaccessibility and loss of your significant data that requires excel recovery.

How to fix this issue
You can handle Excel corruption scenarios using third party repair software. These software are particularly designed to methodically scan your corrupted Excel file and extract all data from it.

Excel Recovery software can recover all the Excel workbook objects including charts, pivot tables, images, hyperlinks, embedded function, text strings and fields. With interactive user interface and read-only design, these software are easy and safe to use.

In order to have successful excel repair, you are suggested to go for powerful Excel utilities that offer precise, instant, safe and interactive recovery experience.

Stellar Phoenix Excel Recovery is the ultimate solution to all your Excel workbook corruption related problems. It can repair all Excel files that are created using Microsoft Excel 2007, 2003, 2002 (XP) and 2000. It supports Windows Vista, XP, 2003, 2000 and NT.

Excel Corruption Due to Virus Infected Macros

When you try to open a Microsoft Excel spreadsheet, you may encounter one of the following error messages:
“This workbook contains one or more Microsoft Excel macros. These macros may contain viruses or other harmful code. These macros will be disabled.”
Or
“This workbook contains one or more Microsoft Excel macros. These macros may contain viruses or other harmful code. Open this workbook only if you trust the source. Do you want to enable these macros?”
After these error messages, either your spreadsheet can not be opened or the macros get disabled.
Grounds of this issue
You might encounter these error messages if your Excel workbook contains macros. Macros are predefined functions that execute a series of precise steps automatically within the program like Microsoft Excel 2003 when you open a workbook.
Because macros sometimes contain malevolent codes when you get them from external sources, you may face this behavior of Microsoft Excel. These malicious code constructs may possibly corrupt the spreadsheet and may make its content inaccessible.
Resolution
There are two possible solutions of this problem:
.   Uninstall or disable all the macros.
.    If you believe that macros do not contain viruses, change the security settings of Excel (If Security Certificate is not an issue, if it is expired, you need to get an updated version of the certificate/application).
In these cases, you will not be able use macros and perform the operations for which you included them in your spreadsheet.
In other scenario, these solutions are not applicable on corrupted Excel spreadsheet. To fix the corruption, you are required to use excel recovery software to repair corrupted Excel spreadsheets.
Stellar Phoenix Excel Recovery is the most advanced and user friendly Excel Repair software. It can effectively handle almost all Excel corruption situations. It ensures successful extraction of your spreadsheet data after repairing corrupted Excel file.
Phoenix Excel Recovery software comes equipped with interactive user interface and rich graphical support that enables you to perform ‘Do It Yourself’ Excel Repair. It can repair all your Excel spreadsheet objects such as macros, pivot tables, formulas, text and lists. You can use this excel repair software with Microsoft Excel 2007, 2003, 2002 and 2000.  It supports Windows Vista, XP, 2003, 2000 and NT.

How to Correct Errors While Opening the Spreadsheet in Microsoft Office Excel 2003

When you try to open an Excel Workbook in Microsoft Office Excel 2003, you might encounter the following error message:

“Errors were detected in ‘filename.xls,’ but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent.”

This error message might be followed by the underwritten error message when you try to save file:

“Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.”

The problematic workbook might open without any problem with earlier versions of Microsoft Excel.

Grounds of this issue
You might encounter this behavior of Microsoft Excel if the particular workbook is corrupted or damaged. It might take place though the workbook opens in earlier version of Excel without any issue.
In such conditions, to gain access of your mission critical data, you need to perform Excel Recovery by fixing this scenario as quickly as possible.

Resolution
To easily and effectively handle the situation, follow the below mentioned steps:
.    Open the workbook in earlier version of Microsoft Excel.
.    Copy data from it and then paste to a new workbook opened in Excel 2003.
.    Save the file.

This method works in most of such cases and allows you to have easy Excel Repair. But if Excel does not allow you to even open the workbook due to extensive corruption, then you might not resolve the problem using this process.

In such situations, you are advised to go for excel recovery software to systematically scan the corrupted file and extract all of its data and objects out from it. Excel Repair software are generally very easy to use and enable you to have safe and original Excel Recovery.

Stellar Phoenix Excel Recovery is the most comprehensive and result-oriented excel repair tool that can handle most of the Excel corruption scenarios. Phoenix Excel Repair software works well with Microsoft Excel 2007, 2003, 2002 and 2000.

Excel Spreadsheet Corruption Due to Invalid Page Fault

Sometimes when you start Microsoft Excel 2000, you might encounter the below error message:

“This program has performed an illegal operation and will be shut down.”

When you click on ‘Details’, you might get another error message as:

“Excel caused an invalid page fault in module Excel.exe at memory address”

You may receive these error messages while working on a new spreadsheet, any existing one or when you simply open MS Excel.

Cause
You might encounter this problem due to corruption of Excel.xlb file of Microsoft Excel. Corruption to this file may also damage the Excel spreadsheet and may cause the above errors.
.    Excel.xlb is a system file of Microsoft Excel that stores information about the menu changes, other type of changes, toolbars, file header information, custom menus and various important data.

In such situations, to gain access of your precious data, you need to perform Excel Recovery by solving this problem.

Resolution
You can fix this issue by following these simple steps:
.    Start Microsoft Excel 2000 in Safe Mode.
.    Use Windows Explorer to locate .xlb file in C:\Windows\Application Data\Microsoft\Excel folder. The .xlb file has any of the following names:

.    Excel.xlb if your system isn’t connected to network.
.    Username.xlb where the Username is your logon name.
.    Right-click on .xlb file and select Rename and rename it as Excel.old or Username.old.
.    Exit Windows Explorer and start Excel 2000 and customize your toolbar again.

After applying this solution, the problem should not occur in future but it can not repair the corrupted Excel spreadsheet. To get Excel spreadsheet repaired, you need to go for Excel Recovery.

Excel Recovery software are specifically designed to extract data from your corrupted or damaged Excel spreadsheet. To ensure absolute repair excel, you should opt for powerful Excel Recovery software.

Stellar Phoenix Excel Recovery is the most advanced and commanding tool to provide the best Excel Repair. With dominant scanning mechanisms, this Excel Recovery software is capable of scanning the corrupted file thoroughly and extracting all the data from it. Phoenix excel recovery can recover charts, text, images, hyperlinks and other data from Excel spreadsheet. This Excel Repair software is compatible with Microsoft Excel 2007, 2003, 2002 and 2000. It supports Windows Vista, XP, 2003, 2000 and NT.