Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 encountered a problem and needs to close
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. -- Don H. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Close problem | Excel Discussion (Misc queries) | |||
Microsoft Excel encountered a problem and needs to close | Excel Discussion (Misc queries) | |||
Microsoft Excel has encountered a problem and needs to close. HELP! | Excel Discussion (Misc queries) | |||
Problem encountered | Setting up and Configuration of Excel | |||
Problem encountered when cutting and pasting | Excel Discussion (Misc queries) |