Ron - I appreciate your help, and I think you are on to something. The
formulas link to another spreadsheet in the same workbook. One of the links
is not working when I re-open the workbook, it also has "=N/A" in it rather
than the link. I just re-established the link and closed and re-opened the
workbook, and it went right back to "=N/A". I am also getting a message when
I open the workbook of "File Error: Data may have been lost" which may be at
the root of this problem.

I would welcome any comments or suggestions. Thanks.

"Ron Rosenfeld" wrote:

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