CODEWITHSUNDEEP
excelactivexexcel-2007rexcel
Lisa Ann
Lisa Ann

Reputation: 3485

Recovering datas from an Excel/ActiveX spreadsheet

I'm having the following issue: I've an Excel spreadsheet with a lot of VBA codes and ActiveX controls, including RExcel formulas.

The Excel version is 2007.

When I try to open this file, Task Manager says Excel isn't answering and something starts like if Excel started running endless codes; I deactivated each control and it still seems broken.

I would like to recover at least some formulas I've written in that spreadsheet, but this is actually impossible by opening the spreadsheet in conventional way.

Could you tell me how I can "read" formulas and text in that spreadsheet without opening it by Excel?

Thanks,

Upvotes: 1

Views: 401

Answers (2)

SeanC
SeanC

Reputation: 15923

use a tool like 7zip to extract the files. the sheets/formulas are in the .xml

xlsm opened with 7zip

the code in a macro enabled spreadsheet is in a .bin file
this can be read with MalOfficeScanner

Upvotes: 1

K_B
K_B

Reputation: 3678

Indeed have calculation set to manual for a start.

Now set your security settings such that macros and activeX are disabled:

Excel Options > Trust Center > Trust Center Settings... > Macro Settings > Disable all macros with notification

For ActiveX I am not sure if there is a menu in excel-2007 like for macros, but if there is make sure it is set to not run as well.

Now you can open your excel workbook and it will not run your macro's and shouldn't auto calculate or update!

ADDED: I have had something like this in the past and this is what worked in 1 occasion: install an other office excel application, like open office (the calc application has the excel functionality) and see if it opens in that application. Then if it does, save the file (under another file name) and close it. Open the new file under MS Office Excel, and see what is still recoverable.

Good luck!

Upvotes: 1

Related Questions