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?
Tell me more
×
Super User is a question and answer site for
computer enthusiasts and power users. It's 100% free, no registration required.
migrated from stackoverflow.com Dec 10 '12 at 3:02
|
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. |
|||
|
