I got nothing!

Maybe one more question....

If you start excel in safe mode, does it help?

close excel
windows start button|run
excel /safe

(I'm not sure what my answer would be if you said yes or no, though.)



fred wrote:

Thanks Dave,

Just guesses...

If you copy the cells to a new worksheet in a new workbook, does it help?


yep, still happens. I've done that about 5 times now. I copied the top
cells to a new blank workbook and all is fine until I do the big copy down
of all the formulas. Then I start getting the 'close error.' In fact I
started deleting rows from the bottom and found that the error went away
when I got down to 2325 rows!

It's starting to look like there is some size limit I'm exceeding. Maybe
related to RAM size or Virtual Memory size. Does anyone know what Excel
does when it closes? If the file is already saved, what's all the activity
about? .... It doesn't just close immediately. I noticed that when I
crashes it doesn't save the recently-opened files in the list.

I'm assuming the error upon closing my workbook isn't affecting the
calculations in the workbook .............. I hope!

Also, I a long time ago I noticed 'auto-recover' caused a lock up, so I
turned that off. I'm not sure if that's related or not.

--

Dave Peterson