Well, I'm still using it, even though
I can't shut it down without a crash.
I can still save, edit, undo, etc. ..........
I guess I'll just have to live with the crashing.

I thank you for giving it a shot anyway.

Fred


"Dave Peterson" wrote in message
...
Excellent questions all, but I don't have an answer for any of them.

When you loaded it in Safe mode, I figured that all the things that excel
does
special would be disabled. But it still blew up!

(yeah, no help at all. Sorry.)



fred wrote:

50 columns x 10,000 rows, 50 meg file.

no, no conditional formatting in this particular workbook

I started deleting rows from the bottom
after I had deleted enough so I had only 2325 rows left,
the error went away.

Is there any resource that would know
what Excel does when it closes?
I mean, the file is saved, what is it doing
that's getting an error? Could it be some sort
of admin thing, like closing virtual memory?
Why doesn't it just close the window and be done with it?

"Dave Peterson" wrote in message
om...
I saw your message that it worked when you reduced the number of
rows--but your data didn't sound very big to me to begin with.

By chance, do you have lots of conditional formatting or objects (even
comments) in your worksheet? I may not be remembering this correctly,
but I think I had some problems when I had lots of these.

Safe mode stops excel from doing lots of things when it opens. It
disables addins, macros, and essentially opens excel in plain vanilla
mode.




"fred" wrote in message
...
most interesting, 'safe mode' for Excel....
what is it?

anyway, I still got the error when I closed :(

btw, I put an answer inline with your question
did you notice that I said the problem went away
when I had deleted enough lines off the bottom of the sheet?

It sure seem like a memory limit.
I expected safe mode might work, but it didn't.


"Dave Peterson" wrote in message
...
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


--

Dave Peterson