Hi,
I’m working with a user who is using XIRR in a bunch of formulas on one sheet of a very large book (10 mgs, 150 sheets). All the XIRRs are working for her except one. It produces a #VALUE error anytime the workbook is calced. And then everytime you activate the cell with F2 and hit ENTER, it gets the correct value.
We’ve tried the file on every computer at our little help desk, and none of us get the error. The XIRR always calculates just fine. We’ve been to see the user. Her calc settings are standard, with iterations on, she’s rebooted several times, and she still gets the error.
More bizarrely, on her computer, when the #VALUE error is showing in the cell, if we select the XIRR in the formula bar and F9 it, it shows the correct result. But calcing still produces the error.
We checked the book for corruption – names, styles, etc. , used Ron Bovey’s code cleaner on the modules. No improvement. We have had the experience before of seeing corrupt files where some formulas wouldn’t calculate for users, but calced fine on our more-powerful machines. But this always went away after we cleaned up the file. Not in this case.
With the error showing, we copied the values the XIRR was referencing to another file, and the XIRR worked fine there.
We recommended that the user consolidate her file on fewer sheets, but she said that this was impossible for business reasons.
Anybody ever see anything like this before, or have any thoughts?
Thanks a lot for you time.
