On Thu, 17 Apr 2008 10:18:03 -0700, Terry McCoy <Terry
wrote:

I have an issue with the XIRR and XNPV functions in Excel 2007. The formulas
seem to be operating properly, but when I go back into the spreadsheet after
closing it, the cells where the formulas were now say #N/A. I have not made
any changes to the spreadsheet. I do not have the analysis toolpak checked
on the add-ins, but I understand that these functions are integral to Excel
2007, so I should not need the toolpak. I would appreciate any help anyone
can give me with this issue. Thanks,

Terry McCoy

#N/A indicates that a value is not available to the function or formula.

Could it be that some of the source data is not in an available workbook, at
the time you reopen the workbook containing the function?
--ron