No, there aren't any #N/A's in the range that I'm look at, its all
company names. So I don't understand. Oddly enough, ONE of the
SUMPRODUCT functions now works this morning but the others are still
broken. I've built a macro that opens and closes all the files that are
references, but maybe its time to learn VBA and build a small app that
does the calculations for me.

Still not sure what excel is up to, thanks for your help Richard, if
you have any ideas I'm sure up for hearing them.

J.

Richard?


Do you have any UDF's in your workbook?

Under some versions of excel (xl97, IIRC), if the UDF encountered an unhandled
error, it could affect calculation.

Egon wrote:

No, there aren't any #N/A's in the range that I'm look at, its all
company names. So I don't understand. Oddly enough, ONE of the
SUMPRODUCT functions now works this morning but the others are still
broken. I've built a macro that opens and closes all the files that are
references, but maybe its time to learn VBA and build a small app that
does the calculations for me.

Still not sure what excel is up to, thanks for your help Richard, if
you have any ideas I'm sure up for hearing them.

J.

--

Dave Peterson

I don't have any UDF's that should be unhandled that I'm aware of, but
its certainly odd behavior for sure. I'm thinking that maybe using VBA
to build it might be better and more stable anyway at this point.

J.

One more try???

Open excel in safe mode
(Close excel first)
windows start button|run
excel /safe
file|open yourworkbook.xls

Does it recalculate correctly?

(Did you try this already?)

Egon wrote:

I don't have any UDF's that should be unhandled that I'm aware of, but
its certainly odd behavior for sure. I'm thinking that maybe using VBA
to build it might be better and more stable anyway at this point.

J.

--

Dave Peterson