D
Dean
I think I need to ask this question every two years or so and hope that the
answer will improve, due to technology.
A few months ago, I created an EXCEL file that is ever evolving with lots of
data tables and graphs, though only about 4 MB. Each time I modify it, an
average of once a day, I give it a new name so I have hundreds of versions.
Maybe three times, over the last 3 months, the latest file at that time has
crashed EXCEL when I open it. Unlike my files in the past, wherein EXCEL's
slow repair seems to wipe out most cell formats, suggesting it might not be
totally fixed, but with leaving the algebra working fine I can tell, this
time it is repaired in about 5 seconds, with no warning, and everything
looks fine, including formats. If I resave the corrected file, all is well.
I do have an older file that doesn't crash that I could start with and
recreate the new changes in about 2 hours, but since an ancestor of all
these files has crashed once or twice in an earlier version, I wonder if I
should bother.
I can print out this technical information about the error report. Will
that mean anything to anyone here? It goes thru 40 modules, etc. I would
love to know what I've done that creates these kinds of problems, whether
excessive formatting or whatever.
Thanks!
Dean
answer will improve, due to technology.
A few months ago, I created an EXCEL file that is ever evolving with lots of
data tables and graphs, though only about 4 MB. Each time I modify it, an
average of once a day, I give it a new name so I have hundreds of versions.
Maybe three times, over the last 3 months, the latest file at that time has
crashed EXCEL when I open it. Unlike my files in the past, wherein EXCEL's
slow repair seems to wipe out most cell formats, suggesting it might not be
totally fixed, but with leaving the algebra working fine I can tell, this
time it is repaired in about 5 seconds, with no warning, and everything
looks fine, including formats. If I resave the corrected file, all is well.
I do have an older file that doesn't crash that I could start with and
recreate the new changes in about 2 hours, but since an ancestor of all
these files has crashed once or twice in an earlier version, I wonder if I
should bother.
I can print out this technical information about the error report. Will
that mean anything to anyone here? It goes thru 40 modules, etc. I would
love to know what I've done that creates these kinds of problems, whether
excessive formatting or whatever.
Thanks!
Dean