Excel crashes when editing source data in charts

[Rocket_Mk2]

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

Hi I have created a new spreadsheet in excel and have plotted the data on a number of charts (actually 10) created in separate worksheets. I am saving this in xls format. Every time I click on a line on the graph and select source data the spreadsheet crashes with an error message. The error log is shown below. When the file re-opens I can select source data without it crashing. As soon as I open another chart to edit the source data it happens again.

Please help?

Microsoft Error Reporting log version: 2.0

Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2009-07-03 14:51:46 +0100
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.1.9.090515
Crashed Module Name: Microsoft Excel
Crashed Module Version: 12.1.9.090515
Crashed Module Offset: 0x00178c38
Blame Module Name: Microsoft Excel
Blame Module Version: 12.1.9.090515
Blame Module Offset: 0x00178c38
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409

Thread 0 crashed:

# 1 0x00179c38 in __mh_execute_header + 0x00178C38 (Microsoft Excel + 0x00178c38)
# 2 0x0017cc33 in __mh_execute_header + 0x0017BC33 (Microsoft Excel + 0x0017bc33)
# 3 0x006128fc in __mh_execute_header + 0x006118FC (Microsoft Excel + 0x006118fc)
# 4 0x006129a1 in __mh_execute_header + 0x006119A1 (Microsoft Excel + 0x006119a1)
# 5 0x00612ac8 in __mh_execute_header + 0x00611AC8 (Microsoft Excel + 0x00611ac8)
# 6 0x01a7e18f in _MsoFCreateToolbarSet + 0x00000D5F (MicrosoftOffice + 0x0033d18f)
# 7 0x01a7e49a in _MsoFCreateToolbarSet + 0x0000106A (MicrosoftOffice + 0x0033d49a)
# 8 0x014f405b in _McpFCreateControl + 0x00000829 (MicrosoftComponentPlugin + 0x0008b05b)
# 9 0x014f5213 in _McpFCreateControl + 0x000019E1 (MicrosoftComponentPlugin + 0x0008c213)
# 10 0x014f3f0b in _McpFCreateControl + 0x000006D9 (MicrosoftComponentPlugin + 0x0008af0b)
# 11 0x0153a2bf in _McpCreateControlContainer + 0x00003F25 (MicrosoftComponentPlugin + 0x000d12bf)
# 12 0x015b4110 in _McpGetTBWindow + 0x00000664 (MicrosoftComponentPlugin + 0x0014b110)
# 13 0x015ce240 in _McpCursorSet + 0x000038BA (MicrosoftComponentPlugin + 0x00165240)
# 14 0x015ce34f in _McpCursorSet + 0x000039C9 (MicrosoftComponentPlugin + 0x0016534f)
# 15 0x01a78d57 in _MsoFCreateControl + 0x0000DFAD (MicrosoftOffice + 0x00337d57)
# 16 0x00605f76 in __mh_execute_header + 0x00604F76 (Microsoft Excel + 0x00604f76)
# 17 0x00056c9f in __mh_execute_header + 0x00055C9F (Microsoft Excel + 0x00055c9f)
# 18 0x000fe31e in __mh_execute_header + 0x000FD31E (Microsoft Excel + 0x000fd31e)
# 19 0x00280c10 in __mh_execute_header + 0x0027FC10 (Microsoft Excel + 0x0027fc10)
# 20 0x00051d89 in __mh_execute_header + 0x00050D89 (Microsoft Excel + 0x00050d89)
# 21 0x0030ab9b in __mh_execute_header + 0x00309B9B (Microsoft Excel + 0x00309b9b)
# 22 0x000fe117 in __mh_execute_header + 0x000FD117 (Microsoft Excel + 0x000fd117)
# 23 0x00605620 in __mh_execute_header + 0x00604620 (Microsoft Excel + 0x00604620)
# 24 0x00c4401f in __mh_execute_header + 0x00C4301F (Microsoft Excel + 0x00c4301f)
# 25 0x00c44066 in __mh_execute_header + 0x00C43066 (Microsoft Excel + 0x00c43066)
# 26 0x01b1196b in _SetSubDlgExtraSize + 0x00000C39 (MicrosoftOffice + 0x003d096b)
# 27 0x01afb68c in _SetFdlgOfHdlgCur + 0x000005BA (MicrosoftOffice + 0x003ba68c)
# 28 0x01b0dc3b in _SetTmcTxs + 0x00003DF9 (MicrosoftOffice + 0x003ccc3b)
# 29 0x01b0a5ad in _SetTmcTxs + 0x0000076B (MicrosoftOffice + 0x003c95ad)
# 30 0x01b02d03 in _FIsOfficeDlg + 0x000006A3 (MicrosoftOffice + 0x003c1d03)
# 31 0x01b0125b in _HcabFromDlg + 0x00000807 (MicrosoftOffice + 0x003c025b)
# 32 0x01b02535 in _TmcDoDlgDli + 0x000000C5 (MicrosoftOffice + 0x003c1535)
# 33 0x0060518a in __mh_execute_header + 0x0060418A (Microsoft Excel + 0x0060418a)
# 34 0x00656fa9 in __mh_execute_header + 0x00655FA9 (Microsoft Excel + 0x00655fa9)
# 35 0x00c43ff5 in __mh_execute_header

 

[Rocket_Mk2]

EDIT : just to clarify the crash is everytime I right click on a line in a graph, then select "select data". It is not "source data" as I mistakenly posted above.

 

[CyberTaz]

See the thread entitled: [Excel Crashes on Editing Chart] which was started
earlier this morning by Sorcerer2008.

FWIW, I'm currently on a PPC Mac running OS X 10.4.11 without experiencing
any such behavior. I've not tried the scenario on my Leopard/Intel system,
however. Perhaps the reference in that conversation to the Spaces feature of
Leopard may apply for you as well.

Just to be on the safe side & avoid confusion, though, please keep any
further discussion of your situation confined to this thread. Also, I'm
afraid it's utterly pointless to post these lengthy error reports. The folks
who hang out here are other users -- not systems engineers or developers --
so the only thing most of us can decipher from them is the one line which
refers to "Application Version:" so it's best to simply submit the report &
include only your exact update level when posting to the newsgroup.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[Rocket_Mk2]

Cheers for the reply, yes it is the same problem. I didn't spot that thread before posting mine doh.. I also have an old PPC G4, 10.4.11 running Office 2000 and this is fine. Although it fails to show some of the charts - but thats another problem..

 

[Rocket_Mk2]

Additional info: This error happens on every new worksheet/graph I create.