When save as another file, EDATE and XIRR functions return #N/A

N

nguyensea

Please help. Sometimes the functions work, sometimes they don't. When they
don't, if I save the file as another file (in Excel 2007 or earlier version),
EDATE and XIRR disappear and are replaced by #N/A. I already update Add-in
Toolpak. Thanks.
 

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

Similar Threads

XIRR and EDATE functions return as #NA in 2007 in compatability mo 6
xirr #N/A 6
Lookup functions always return n/a ??? 3
XIRR #NAME? error - Toolpak IS installed 1
Can't save my Office documents (after computer rebuild and reauthorization) 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Same experience 0
Calculating quarterly investment returns---XIRR or another function?? 13

Top