D
donh
I have a large, multi-sheet workbook that has worked fine in Excel 2003 for
several years. When opened in Excel 2007, it opens fine. But any change,
anywhere, that causes it to recalculate the workbook immediately crashes
Excel with the subject error message.
I've isolated the problem to a specific sheet within the workbook. But in
attempting to isolate the problem to a specific row or rows, I find that
there doesn't seem to be any specific row that causes the problem. Deleting
some number of rows seems to make it go away (and the rest of the workbook
works), but if I then put those rows back and delete other rows, the problem
also goes away. It's as though there is some memory limit that is being
exceeded, or something like that.
However, although it's large, this workbook is nowhere near the legal limits
on numbers of rows and columns supported by Excel.
I believe that there must be a bug in Excel that I'm tripping over. My
desire right now is to simply understand what I might be able to change in
the workbook such that I can circumvent the bug. But I'm having trouble
doing that.
If someone at Microsoft wants to look at this, I'm happy to e-mail the
workbook, with a detailed description of how to trigger the bug. Perhaps
someone who could use the debugger in Excel could quickly determine what's
blowing up, and suggest a way to avoid the problem.
Thanks.
several years. When opened in Excel 2007, it opens fine. But any change,
anywhere, that causes it to recalculate the workbook immediately crashes
Excel with the subject error message.
I've isolated the problem to a specific sheet within the workbook. But in
attempting to isolate the problem to a specific row or rows, I find that
there doesn't seem to be any specific row that causes the problem. Deleting
some number of rows seems to make it go away (and the rest of the workbook
works), but if I then put those rows back and delete other rows, the problem
also goes away. It's as though there is some memory limit that is being
exceeded, or something like that.
However, although it's large, this workbook is nowhere near the legal limits
on numbers of rows and columns supported by Excel.
I believe that there must be a bug in Excel that I'm tripping over. My
desire right now is to simply understand what I might be able to change in
the workbook such that I can circumvent the bug. But I'm having trouble
doing that.
If someone at Microsoft wants to look at this, I'm happy to e-mail the
workbook, with a detailed description of how to trigger the bug. Perhaps
someone who could use the debugger in Excel could quickly determine what's
blowing up, and suggest a way to avoid the problem.
Thanks.