conditional sum wizard crashes in Excel 2004 v. 11.2

[Howard]

I'm having problem with CSW crashing whenever I try to use it. Any ideas?

 

[Bob Greenblatt]

I'm having problem with CSW crashing whenever I try to use it. Any ideas?

Not without some more information. What is the data? What are you entering?
When does it crash? Are there any messages? Dos it fail on a workboks?

 

[Howard]

Thanks for the reply, Bob, and sorry for my lack of clarity. I was frustrated.

I've a large workbook with multiple tabs. I want to enter a CS formula on one tab referencing data on another tab. That data, whole dollar amounts, will change frequently. I am able to create the formula, using CSW, and do use Command+Enter. However, when I enter more data on the referenced tab; Excel crashes, giving me an "the application Excel quit unexpectedly" message.

Sometimes it crashes right after I enter data relevant to that formula, sometimes it crashes when I enter any data on that tab.
I can't discern a pattern.

BTW: I did update Excel to v. 11.3.5; we are using OS 10.4.11. Problem still occurs.

Thanks.
Howard

 

[JE McGimpsey]

I've a large workbook with multiple tabs. I want to enter a CS formula on one
tab referencing data on another tab. That data, whole dollar amounts, will
change frequently. I am able to create the formula, using CSW, and do use
Command+Enter. However, when I enter more data on the referenced tab; Excel
crashes, giving me an "the application Excel quit unexpectedly" message.

Sometimes it crashes right after I enter data relevant to that formula,
sometimes it crashes when I enter any data on that tab.
I can't discern a pattern.

BTW: I did update Excel to v. 11.3.5; we are using OS 10.4.11. Problem still
occurs.

It's possible that your workbook has become corrupted.

Try copying and pasting to a fresh workbook. PITA with multiple sheets,
but it usually solves that sort of crash.