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



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?


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question