View Single Post
  #1  
Old September 22nd, 2004, 04:38 PM

AMF AMF is offline
Lieutenant Colonel
 
Join Date: Dec 2000
Posts: 1,254
Thanks: 0
Thanked 0 Times in 0 Posts
AMF is on a distinguished road
Default OT: Can anyone help me with this Excel problem??!!

I have a serious problem with Excel that if anyone couldhelp me with I would give them my firstborne child.

I have a workbook, that is BIG. Many sheets, many of them very large and with oodles of calculations. I worked on it yesterday, saved it fine, tried to open it today, and I keep getting "out of memory" errors, and then Excel crashes. I disable macors, but that doesn't help - still crashes every time.

I know that if I can sucessfully open the file even ONCE, I can do things like turn off auto-calculations, delete some worksheets, get rid of a bunch of calculations, and split it into multiple workbooks and thus I can get the size down from it's current 61 Megs to something manageable...but I can't get it open, at all. I feel like a dumba** to have gotten into a rookie mistake like this, but I was never very proficient at the ins and outs of Excel...

So...does anyone know of a way in Excel, or maybe using a third party utility, that will allow me to do things like move/delete worksheets in a workbook, split a workbook up, delete calculations, etc...in an Excel file without opening the whole thing? Or some other way around this memory problem? I am going to try to find a machine that has more memory and try it on there, but I've already done that once with no luck so far.

I, and my job, would be very very grateful to anyone who could help me out with this.

Thanks,

Alarik
Reply With Quote