Excel crashes randomly when entering data

[Tony]

Operating System: Mac OS X 10.4 (Tiger)
Processor: intel

I had this issue when I was using Excel 2004, and the same problem exists even after I upgraded to Excel 2008. ALL previous versions of Office were removed during the install of Office 2008.

The error...

There's a small group of cells in a worksheet that, when any data is entered, causes Excel to crash. For instance, in the particular workbook I'm working in, there are 3 worksheets. Only one of the sheets has an issue. When using this sheet, the group of cells at E85:G89 cannot have any data entered. The cells at I81:J91 will not affect a formula in cell L92 that totals all the formulas in row 92 (that are themselves sums of the columns above).

I recreated the workbook from scratch in Excel 2008 and encountered the same problems. The original file was created in Excel 2004.

At this point, I'm not sure whether to think there's corruption in the file, program, or system. There are other, similar files with the same problem; those files are the same except for a different date range (though the same kind of data; we use one file for each month).

Any ideas or do I need to provide more information?

Thanks!
Tony

 

[Tony]

From "More Information" when Excel crashes...

Microsoft Error Reporting log version: 2.0

Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2008-03-25 08:38:01 -0700
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.0.1.080305
Crashed Module Name: Microsoft Excel
Crashed Module Version: 12.0.1.080305
Crashed Module Offset: 0x00163520
Blame Module Name: Microsoft Excel
Blame Module Version: 12.0.1.080305
Blame Module Offset: 0x00163520
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409

Thread 0 crashed:

# 1 0x00164520 in __mh_execute_header + 0x00163520 (Microsoft Excel + 0x00163520)
# 2 0x0016c99e in __mh_execute_header + 0x0016B99E (Microsoft Excel + 0x0016b99e)
# 3 0x00211cb9 in __mh_execute_header + 0x00210CB9 (Microsoft Excel + 0x00210cb9)
# 4 0x00213262 in __mh_execute_header + 0x00212262 (Microsoft Excel + 0x00212262)
# 5 0x001cc998 in __mh_execute_header + 0x001CB998 (Microsoft Excel + 0x001cb998)
# 6 0x001ccaea in __mh_execute_header + 0x001CBAEA (Microsoft Excel + 0x001cbaea)
# 7 0x00639fe6 in __mh_execute_header + 0x00638FE6 (Microsoft Excel + 0x00638fe6)
# 8 0x0063a526 in __mh_execute_header + 0x00639526 (Microsoft Excel + 0x00639526)
# 9 0x0063a871 in __mh_execute_header + 0x00639871 (Microsoft Excel + 0x00639871)
# 10 0x00a44ef1 in __mh_execute_header + 0x00A43EF1 (Microsoft Excel + 0x00a43ef1)
# 11 0x00a44ff4 in __mh_execute_header + 0x00A43FF4 (Microsoft Excel + 0x00a43ff4)
# 12 0x00a471b4 in __mh_execute_header + 0x00A461B4 (Microsoft Excel + 0x00a461b4)
# 13 0x020a3128 in MEventHandler::FRemoveHandler(unsigned long, unsigned long) + 0x000001DE (MicrosoftComponentPlugin + 0x0009b128)
# 14 0x92df54d7 in DispatchEventToHandlers(EventTargetRec*, OpaqueEventRef*, HandlerCallRec*) + 0x00000445 (HIToolbox + 0x000084d7)
# 15 0x92df4b7c in SendEventToEventTargetInternal(OpaqueEventRef*, OpaqueEventTargetRef*, HandlerCallRec*) + 0x00000130 (HIToolbox + 0x00007b7c)
# 16 0x92dfbf7c in _SendEventToEventTarget + 0x00000038 (HIToolbox + 0x0000ef7c)
# 17 0x92dfc69a in ToolboxEventDispatcherHandler(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*) + 0x0000071C (HIToolbox + 0x0000f69a)
# 18 0x92df588e in DispatchEventToHandlers(EventTargetRec*, OpaqueEventRef*, HandlerCallRec*) + 0x000007FC (HIToolbox + 0x0000888e)
# 19 0x92df4b7c in SendEventToEventTargetInternal(OpaqueEventRef*, OpaqueEventTargetRef*, HandlerCallRec*) + 0x00000130 (HIToolbox + 0x00007b7c)
# 20 0x92dfbf7c in _SendEventToEventTarget + 0x00000038 (HIToolbox + 0x0000ef7c)
# 21 0x92f1c15e in _SendTSMEvent + 0x000000FB (HIToolbox + 0x0012f15e)
# 22 0x92f1b85a in _SendUnicodeTextAEToUnicodeDoc + 0x0000042A (HIToolbox + 0x0012e85a)
# 23 0x92f1b1d0 in _TSMKeyEvent + 0x0000044B (HIToolbox + 0x0012e1d0)
# 24 0x92ecf39b in _TSMProcessRawKeyEvent + 0x00000AE2 (HIToolbox + 0x000e239b)
# 25 0x92df1bff in HIApplication::EventHandler(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*) + 0x0000099D (HIToolbox + 0x00004bff)
# 26 0x92df54d7 in DispatchEventToHandlers(EventTargetRec*, OpaqueEventRef*, HandlerCallRec*) + 0x00000445 (HIToolbox + 0x000084d7)
# 27 0x92df4b7c in SendEventToEventTargetInternal(OpaqueEventRef*, OpaqueEventTargetRef*, HandlerCallRec*) + 0x00000130 (HIToolbox + 0x00007b7c)
# 28 0x92df4a41 in _SendEventToEventTargetWithOptions + 0x00000037 (HIToolbox + 0x00007a41)
# 29 0x92dfc5e4 in ToolboxEventDispatcherHandler(OpaqueEventHandlerCallRef*, OpaqueEventRef*, void*) + 0x00000666 (HIToolbox + 0x0000f5e4)
# 30 0x92df588e in DispatchEventToHandlers(EventTargetRec*, OpaqueEventRef*, HandlerCallRec*) + 0x000007FC (HIToolbox + 0x0000888e)
# 31 0x92df4b7c in SendEventToEventTargetInternal(OpaqueEventRef*, OpaqueEventTargetRef*, HandlerCallRec*) + 0x00000130 (HIToolbox + 0x00007b7c)
# 32 0x92dfbf7c in _SendEventToEventTarget + 0x00000038 (HIToolbox + 0x0000ef7c)
# 33 0x020f4325

 

[Pat McMillan]

I missed this post when replying to your earlier post. I'll investigate this
crash log and let you know if it helps us understand what's going on.

Thanks,

Pat

 

[Pat McMillan]

Actually, I'll need you to Command + A to select all of the text in the
crash log and resend it. I don't have enough of it here to convert it to
something meaningful.

Thanks,

Pat