formula disappears when file is saved

[cdbcpa]

I have a complex workbook with a spreadsheet that has the following formula in a cell...
=IF($A$34,+K34,0)+IF($A$35,+K35,0)+IF($A$36,+K36,0)+IF($A$37,+K37,0)+IF($A$38,+K38,0)+IF($A$39,+K39,0)+IF($A$40,+K40,0)+IF($A$41,+K41,0)+IF($A$42,+K42,0)+IF($A$43,+K43,0)+IF($A$44,+K44,0)+IF($A$45,+K45,0)+IF($A$46,+K46,0)+IF($A$47,+K47,0)+IF($A$48,+K48,0)+IF($A$49,+K49,0)+IF($A$50,+K50,0)+IF($A$51,+K51,0)+IF($A$52,+K52,0)+IF($A$53,+K53,0)+IF($A$54,+K54,0)+IF($A$55,+K55,0)+IF($A$56,+K56,0)+IF($A$57,+K57,0)+IF($A$58,+K58,0)+IF($A$59,+K59,0)+IF($A$60,+K60,0)+IF($A$61,+K61,0)+IF($A$62,+K62,0)+IF($A$63,+K63,0)+IF($A$64,+K64,0)+IF($A$65,+K65,0)+IF($A$66,+K66,0)+IF($A$67,+K67,0)+IF($A$68,+K68,0)+IF($A$69,+K69,0)+IF($A$70,+K70,0)+IF($A$71,+K71,0)+IF($A$72,+K72,0)+IF($A$73,+K73,0)+IF($A$74,+K74,0)+IF($A$75,+K75,0)+IF($A$76,+K76,0)+IF($A$77,+K77,0)+IF($A$78,+K78,0)+IF($A$79,+K79,0)+IF($A$80,+K80,0)+IF($A$81,+K81,0)+IF($A$82,+K82,0)+IF($A$83,+K83,0)+IF($A$84,+K84,0)+IF($A$85,+K85,0)+IF($A$86,+K86,0)+IF($A$87,+K87,0)+IF($A$88,+K88,0)

A34 through A88 contain either "TRUE" or "FALSE". K34 through K88 contain numbers.

This formula is working on several different machines and in several different environments (excel version 2002 through 2010)...different operating systems.

There is one user that when he saves this file, the cell with the long formula above is replaced with "=#VALUE!" in the cell. Not as just the result of the formula...the cell contents is no longer the formula...it is gone and is replaced with =#VALUE! in the cell contents.

Does anyone know when or why a formula would be overwritten in this manner when a file is saved? Because it is working in so many other instances, I don't think it is the formula, but I'm trying to discover what would trigger a formula to be overwritten like this.

Any help is greatly appreciated.

Corey

 

[tigeravatar]

cdbcpa,

I'm not sure why the formula would disappear unless its hitting a character limit in older versions of excel. But instead of that big long formula, you could use this instead to get the same results:

=SUMIF($A$34:$A$88,TRUE,$K$34:$K$88)

 

[cdbcpa]

Thank you very much. That seems to have resolved the issue. I would have thought if it were a maximum # of characters issue I would have experienced it on several machines...not just one, but ???

Thank you again.

Corey