Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to import formula from a closed Excel workbook that has gotten overly large and hence wont open without crashing Excel. I have a copy of the data but want to get at the formula in one of the tables inside. Most of the solutions I have seen involve extracting data (which I have) or opening the workbook in VBA (which I cant) Does anyone have any thoughts that would help me?

share|improve this question

migrated from stackoverflow.com Dec 10 '12 at 3:02

This question came from our site for professional and enthusiast programmers.

1 Answer 1

I'm not sure if this is version dependant, but it works on Excel 2007.

You can open the file using an archive tool (7-Zip, WinRar), your data will be stored in a sub-folder, "xl/worksheets/[sheet name]".

The data is stored as XML, which you can open using notepad or an XML reader if you have one.

Searching for '<c r="A1">' should take you to the node for cell A1.

share|improve this answer
    
This may work for .pptx files (although, if the file cannot be opened in PowerPoint, it may be corrupt). It will definitely not work for .ppt files (without the x). The same is true for .doc, .docx, .xls, and .xlsx files. (The x stands for XML.) –  Scott Dec 12 '12 at 2:07

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.