Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Where's my result? (2003)

    So, this is weird... We have quite an established spreadsheet that's been used for years. All formulas in the past have worked just fine, even when copying and pasting them. However, now, even the simplest formulas (even something like =C71 or =SUM(C68:C70)) produces 0 for its result. I've never seen this before. I've tried clearing formatting and then recreating a simple formula (in all different places in the spreadsheet) and, still, we get 0. Yet, when I select the numbers I'm trying to add together and look at the QuickSum in the lower-right, that result is correct. Help! Any ideas? Is it an option I'm overlooking?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where's my result? (2003)

    Sounds like calc is on manual. Tools, options, calculation tab.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where's my result? (2003)

    Oh, darn! I was hoping it was that, but my Calculation option is set to Automatic. Any other ideas?

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where's my result? (2003)

    Could you clear out any confidential data and upload a minimum workbook that shows the problem?
    Legare Coleman

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Posts
    51
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Where's my result? (2003)

    Thank you all for your suggestions. Unfortunately, I cannot even clear out enough information to make it non-confidential (it's someone's estate plan) so that I can send a sample. However, I do think I may have found the problem. Somewhere in the worksheet is a circular reference. As soon as I turn on the Iteration feature (Tools - Options - Calculation), the circular reference is fixed and I can then create formulas (that work!). However, once I 'solve' the circular reference, a lot of my numbers change in the spreadsheet. So, now, I have to follow large formulas to make sure I have the correct numbers. Arrrgghh!

  6. #6
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Where's my result? (2003)

    I can recreate the result (not that I really want to...) or something very similar if I set the number format to "0" (including the quotation marks). This forces excel to return the string 0 instead of the numeric result of a formula or input value. Perhaps someone made a mistake in reformating the "normal" style. Change to a different style, or check the normal format: if that's the problem, change the format definition.

Posting Permissions

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