Excel crashes

[Robert A]

I'm running Excel 2003 and I'm working on fairly complex worksheet using
arrays with various formulas. The program is starting to become unstable.
One of the arrays, when entered, causes the program to unexpectedly quit and
then ask me if I want to send an error report to Microsoft. I'm not using
any charting, macros, databases, etc.

Here's the formula that's causing the crash:

=SUMPRODUCT(Port._1*TRANSPOSE(INDIRECT($B44)))

Port._1 is the name of a cell range.

I can't seem to locate anything in the MS knowledgebase. I've replicated
the problem on different computers, so I know it's not isolated to my
computer. I've also installed all my Office '03 updates.

Anyone got a clue?

Thanks in advance.

Robert Ades




___________________________
Robert Ades Accountancy Corp.
12100 Wilshire Blvd., Suite 660
Los Angeles, CA 90025
Tel: 310-571-1224
Fax: 310-571-1227

 

[Bernie Deitrick]

Robert,

I'm not sure that Excel likes names with periods, so it's also possible that
your names are corrupt (an unfortunately common occurance for complex
workbooks).

Download Jan Karel Pieterse's name manager V3.1 from

http://www.jkp-ads.com/Download.htm

install it, then check for names with errors.

If that doesn't help, then I have nothing truly definitive, I'm sorry to
say. However, try building up to your final formula to see where things go
wrong.
Start with simple, and go to more complex:
=SUMPRODUCT(Range1*Range2)
=SUMPRODUCT(Range1*TRANSPOSE(Range3))
=SUMPRODUCT(Range1*TRANSPOSE(INDIRECT("string address of range3")))
=SUMPRODUCT(Range1*TRANSPOSE(INDIRECT($B44)))
=SUMPRODUCT(Port._1*TRANSPOSE(Range3))

HTH,
Bernie
MS Excel MVP

 

[Ken Wright]

That formula works fine for me in 2003, though I had nothing else in the
workbook. I'd still avoid the use of periods though, just because....

 

[Robert A]

Thanks for the suggestions. I'll try them out.

-Robert

 

[Jan Karel Pieterse]

Hi Bernie Deitrick

I'm not sure that Excel likes names with periods, so it's also possible that
your names are corrupt (an unfortunately common occurance for complex
workbooks).

Names with periods should be no problem at all, I use them quite frequently.

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com