Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    3

    Question Unanswered: Excell Bug? Update File!

    Hello,

    I work with a lot link excell files and Acess but everytime I do an update on a specific Excell WorkBook There is one specific formula that gives me an error. Only when I open the source file the excell makes an update.
    The formulas is: =SUMIF('L:\5 - RH\[BD.xls]Dados Básicos'!$J$2:$BQ$500;$B5;'L:\5 - RH\[BD.xls]Dados Básicos'!AS$2:AS$500).

    It's a simple sumif formula!

    Can someone Help Me to solve this excell Bug?

    Best Regards,

    FCosta

  2. #2
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    Does the formula literally return an error, or is the "error" a failure to calculate?

    Try clearing the "Save External link value" checkbox in the Calculation tab of Tools, Options.

  3. #3
    Join Date
    May 2004
    Posts
    3
    Hello anda thanks for the tip but unfortunatly the problem remains

    The Forumula result is: #Value!

    Only when I open the source document the formula works.

    Any Ideia?

    Thanks for your help,

    FCosta

  4. #4
    Join Date
    May 2004
    Posts
    9
    This is a known issue with the sumif/countif/countblank formulas. The source workbook needs to be open for the formula's to work. The workaround is to create an array formula instead. Click here to see the MS KB article relating to this issue.

Posting Permissions

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