Trouble opening file

[cek]

I can't open a workbook I created yesterday. I spent a lot of time on it, so I'd really appreciate ideas on how to get into it. I need the formulas, not just the data. I had 15 sheets of data and 1 sheet of calculations. That sheet had some hlookups that referenced 1 sheet of data. When I got all the calculations set, I copied the sheet and did a replace all to change the references to one of the other 15 sheets of data. I didn't realize it immediately, but I had forgotten to put the labels on all 15 sheets of data, so the hlookups weren't going to work well. So in the process of replacing, Excel froze up and said I didn't have enough memory. I closed the workbooks and said to save it as I exited. I restarted and found I couldn't open my workbook. The task bar shows that there's still memory left, but it's using 100% of the CPU. Since then I've tried opening through explorer, the excel menu, as read only, in safe mode, and with manual instead of automatic calculations. I've also moved by xlb file, started w/o add-ins, and deleted many of my temp files. Any other ideas? Please! Thanks.

 

[Iridium]

A couple of handy links - the second may be more relevant I think:

http://www.cpearson.com/excel/StartupErrors.htm
http://support.microsoft.com/default.aspx?scid=kb;en-us;179871&Product=xlw2K

Also had a quick search of the MS KB on Not enough memory so have a pick through the results

HTH

 

[cek]

Thanks for the links. I couldn't find anything that worked for my file though. So ideas are still appreciated. Thanks.