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?
migrated from stackoverflow.com Dec 10 '12 at 3:02
This question came from our site for professional and enthusiast programmers.
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.