1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

Refreshing Data in Excel from Access

Discussion in 'Other PC Software' started by dishon, 2003/02/07.

Thread Status:
Not open for further replies.
  1. 2003/02/07
    dishon

    dishon Inactive Thread Starter

    Joined:
    2002/02/05
    Messages:
    138
    Likes Received:
    0
    I have a database that has all my suppliers and the prices and discounts they give me in it. When I fill out an Excel Spreadsheet it pulls the price and discount and calculates the unit cost as well as the total cost of all the items. However, when I load the spreadsheet I have to manually refresh the extrernal data. Is there a way that it is automaically updated when I load the spreadsheet?
     
    dishon,
    #1
  2. 2003/02/07
    JohnB Lifetime Subscription

    JohnB Well-Known Member

    Joined:
    2002/01/07
    Messages:
    856
    Likes Received:
    11
    I don't know what version of Excel you are running (I have Excel 2000) but go to Tools>Options>Calculation and under the Workbook Options check the box next to "Update remote references ". Not sure but that may do your auto updates.
     
    JohnB,
    #2


  3. to hide this advert.

Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...