Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jul 2006
    Location
    New York City, New York, USA
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Very Strange Formula Error (2003)

    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.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Very Strange Formula Error (2003)

    I cannot find anything relevant to this problem.
    Does it help if the user closes all other applications on her PC before starting Excel and opening the problem workbook?

  3. #3
    Lounger
    Join Date
    Jul 2006
    Location
    New York City, New York, USA
    Posts
    42
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Very Strange Formula Error (2003)

    Thanks for the reply Hans. I just got back into work now. I'll check this when I see the user later today.
    Best,
    JDB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •