Copy. Attempt to paste. Crash.

[mtpaper]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Into week 2 of my mac and Excel 2008, and it's been quiet and calm and staple.

Today I tried to edit a file that I worked with successfully last night.

Basically, I want to insert a row, copy and paste.
I did the same thing last night without any trouble.

As soon as I try to paste, I get the spinning beachball and have to force-quit.

Things I've tried:
- saving the file without the macros and using the new file
- saving the file again on the old pc, to xlsx, and loading the xlsx version to Excel 2008
- working with other files

What I haven't tried (yet):
- opening the file on my daughter's macbook

What's up?
What can I do to try to isolate what's wrong?
Is there an Excel utility that will tell me the health of a file?

Thank you -
concerned but not frantic in Rochester

 

[mtpaper]

I have also tried:
- copying individual pages to a new workbook; I was optimistic that this solved the crashing but it didnt'

In fact, as I'm typing on this message, Excel just crashed and closed all by itself elsewhere on my desktop.

I think it has to do with linked files that are not healthy.

.....
I've spent hours re-building the file, copying a page at a time, cleaning the links, etc etc etc.

It's still weird. The access time for touching the workbook is tediously slow. I tried to type the text in, rather than copying. Crazy slow. And then it will revive and do a bunch of movements at once.

Somehow, it thinks the links are intense, or there's a circular link, or it thinks it's lined to a file on the network...

not pretty. Any ideas?

 

[Pat McMillan]

Hi,

Can you confirm that you're using Office 12.1.1? If not, I would recommend
upgrading to that version and seeing if the problem still happens.

If you are using 12.1.0 or 12.1.1., would it be possible to send me the
file? I'd love to try to help figure out what's going on here.

Thanks,

Pat McMillan
(e-mail address removed)

 

[mtpaper]

Hi Pat -
I am using 12.1.1

Unfortunately, I don't think I'll be able to send you the file - it is filled with 11 years of confidential info... and, as you know, I can't obliterate the info since I can't copy and paste!

I rebuilt it by copying from old file to new file, page at a time, to isolate the area.

I think the problem had to do with links.

For the moment, altho I searched for any reference to a bad link and didn't find any, I was hesitant to actually delete the link (and have references change to hard numbers). So, my 'creative' workaround was to change the link to a dummy.xls file - I figure, that way, if any cells are looking for info, they'll show up as errors rather than wrong numbers.

I'll be back in touch when/if I have more trouble (you can be sure of that!)

Thank you Pat -
Marion

 

[Pat McMillan]

Thank you Marion. I understand the confidentiality issue with your file. If
you do crash again, please do copy/paste the crash log (from Microsoft Error
Reporting) into an email message and post it to this list or send it to me
directly. We might be able to figure out what's going on by looking at that.

Thanks,

Pat

 

[monoraw]

Hi Pat
I've experienced this problem too.
Excel crashes every time I try to delete cells, or copy cells in a particular workbook. I've experienced this before and appeared to get around it by manually recreating the data in a new workbook. Any chance you could look into it too, I'll send you whatever info you need.
Thanks

Excel 12.1.1
OSX 10.5.4
2.4GHz Intel MacBook

Microsoft Error Reporting log version: 2.0

Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2008-08-12 00:04:50 +0100
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.1.1.080522
Crashed Module Name: Microsoft Excel
Crashed Module Version: 12.1.1.080522
Crashed Module Offset: 0x002a11eb
Blame Module Name: Microsoft Excel
Blame Module Version: 12.1.1.080522
Blame Module Offset: 0x002a11eb
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409

Thread 0 crashed:

# 1 0x002a21eb in __mh_execute_header + 0x002A11EB (Microsoft Excel + 0x002a11eb)
# 2 0x00857dc7 in __mh_execute_header + 0x00856DC7 (Microsoft Excel + 0x00856dc7)
# 3 0x00188d09 in __mh_execute_header + 0x00187D09 (Microsoft Excel + 0x00187d09)
# 4 0x00a48375 in __mh_execute_header + 0x00A47375 (Microsoft Excel + 0x00a47375)
# 5 0x00a4829a in __mh_execute_header + 0x00A4729A (Microsoft Excel + 0x00a4729a)
# 6 0x0150b966 in _McpEnableTimers + 0x000000B8 (MicrosoftComponentPlugin + 0x000ac966)
# 7 0x9122e048 in .objc_class_name_IPMDFontRange + 0x90F04428 (HIToolbox + 0x0009e048)
# 8 0x95ff6b45 in .objc_class_name___NSCFSet + 0x95EACC05 (CoreFoundation + 0x00072b45)
# 9 0x95ff6cf8 in .objc_class_name___NSCFSet + 0x95EACDB8 (CoreFoundation + 0x00072cf8)
# 10 0x911bfda4 in .objc_class_name_IPMDFontRange + 0x90E96184 (HIToolbox + 0x0002fda4)
# 11 0x911bfbbd in .objc_class_name_IPMDFontRange + 0x90E95F9D (HIToolbox + 0x0002fbbd)
# 12 0x91302af3 in .objc_class_name_IPMDFontRange + 0x90FD8ED3 (HIToolbox + 0x00172af3)
# 13 0x0154be3c in _McpRunApplicationEventLoop + 0x0000006A (MicrosoftComponentPlugin + 0x000ece3c)
# 14 0x00a37dea in __mh_execute_header + 0x00A36DEA (Microsoft Excel + 0x00a36dea)
# 15 0x00a38373 in __mh_execute_header + 0x00A37373 (Microsoft Excel + 0x00a37373)
# 16 0x0089065f in __mh_execute_header + 0x0088F65F (Microsoft Excel + 0x0088f65f)
# 17 0x0000284e in __mh_execute_header + 0x0000184E (Microsoft Excel + 0x0000184e)
# 18 0x00002775 in __mh_execute_header + 0x00001775 (Microsoft Excel + 0x00001775)

X86 Thread State:
eax: 0x00000000 ebx: 0x0000003b ecx: 0x00000000 edx:0x00000050
edi: 0xbfff9b90 esi: 0x0000000f ebp: 0xbfffaf18 esp:0xbfff9ac0
ss: 0x0000001f eip: 0x002a21eb cs: 0x00000017 ds:0x0000001f
es: 0x0000001f fs: 0x00000000 gs: 0x00000037 eflags:0x00010206

Thread 1:

# 1 0x928fd5c6 in _signgam + 0x9275DD86 (libSystem.B.dylib + 0x000015c6)
# 2 0x9298629b in _signgam + 0x927E6A5B (libSystem.B.dylib + 0x0008a29b)
# 3 0x020f0d7d in _MerpCreateSession + 0x00000B07 (merp + 0x00002d7d)
# 4 0x020f03e5 in _MerpCreateSession + 0x0000016F (merp + 0x000023e5)
# 5 0x020f046c in _MerpCreateSession + 0x000001F6 (merp + 0x0000246c)
# 6 0x020f0f25 in _MerpCreateSession + 0x00000CAF (merp + 0x00002f25)
# 7 0x9292e6f5 in _signgam + 0x9278EEB5 (libSystem.B.dylib + 0x000326f5)
# 8 0x9292e5b2 in _signgam + 0x9278ED72 (libSystem.B.dylib + 0x000325b2)

X86 Thread State:
eax: 0xffffffa6 ebx: 0x929750bf ecx: 0xb00a0a5c edx:0x928fd5c6
edi: 0x00000194 esi: 0x82032bb8 ebp: 0xb00a0ac8 esp:0xb00a0a5c
ss: 0x0000001f eip: 0x928fd5c6 cs: 0x00000007 ds:0x0000001f
es: 0x0000001f fs: 0x0000001f gs: 0x00000037 eflags:0x00000202

Thread 2:

# 1 0x9290468e in _signgam + 0x92764E4E (libSystem.B.dylib + 0x0000868e)
# 2 0x9292f36d in _signgam + 0x9278FB2D (libSystem.B.dylib + 0x0003336d)
# 3 0x910f7460 in __CMProfileID + 0x9102433C (ColorSync + 0x00033460)
# 4 0x911

 

[Pat McMillan]

Thank you. If you could send me the file and detailed steps that lead to the
crash (which specific cells you're deleting, etc.) and a full crash log
(copy/paste the entire log from Microsoft Error Reporting) it would be
hugely helpful (please send directly to me). We still haven't gotten to the
bottom of this yet.

Thanks,

Pat McMillan
(e-mail address removed)

 

[rw]

Thanks. Have sent the required info to your personal mail.
Hope it helps