formulas changed to #NA in excel 2007 (compatibility mode)

O

Otilija

When I work in excel 2007 (compatibility mode) or excel 2003 users work with
my files, some formulas get changed into #NA (even though they show a
calculated result). The problem is not limited to non-standard formulas like
xnpv or xirr, the change happens to simple formulas (like a link to an input
cell on a different sheet).

How can i avoid this problem?
 
Top