xirr value error
 

Hi,

I am running an XIRR calculation for a series of dates & values while having
my Excel file set on manual calculation. After entering the formula it
returns the correct IRR, but when I either press F9 or save the file the cell
changes to #value!. Does anyone know why this happens and how I can fix the
problem? Thanks for your help!