Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Close problem Duane Nutley Excel Discussion (Misc queries) 4 October 4th 07 12:58 AM
Microsoft Excel encountered a problem and needs to close tiller420 Excel Discussion (Misc queries) 0 February 22nd 07 06:46 PM
Microsoft Excel has encountered a problem and needs to close. HELP! LAF Excel Discussion (Misc queries) 2 April 3rd 06 01:57 PM
Problem encountered Pat Setting up and Configuration of Excel 1 March 3rd 06 03:01 PM
Problem encountered when cutting and pasting limws1 Excel Discussion (Misc queries) 2 July 18th 05 10:45 AM


All times are GMT +1. The time now is 08:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"