Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Feb 2004
    Location
    Jacksonville, Florida
    Posts
    70
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formulas from linked db (9.0/2001)

    The other day I asked if there was a way to link an access db to an Excel ws- and I found an easy way where you make the changes in Access and they reflect in Excel- w/out writing code or anything like that-however when I'm trying to make formulas in 1 ws of Excel based off the info in another ws (which is the link to Access) the formula returns a 0 (it's a sumif statement). Why is that, is it because it's looking at info from a link? But I don't understand how that would make a difference, because it works fm workbook to wb-is it just a finicky glitch?

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

    Re: formulas from linked db (9.0/2001)

    I think the problem must be in your formula, for it shouldn't matter whether the data in Excel are linked to/from Access or not. If you can't determine the cause, could you provide more information? We might decide to move this question to the Excel forum.

Posting Permissions

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