Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Mar 2008
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Linked Cells (Excel 2003)

    I have a workbook with multiple worksheets. Each day i enter values on the different worksheets, then I have a comprehensive worksheet where all of the values are combined and added together. However, my comprehensive worksheet is not updating with the values from the other worksheet. Do you have any idea why this information wouldn't update?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Linked Cells (Excel 2003)

    Source workbooks that you link to should have automatic calculation turned on. To turn automatic calculation on:

    1) Click Tools | Options
    2) Click the Calculation tab
    3) Click Automatic under Calculation

    HTH
    Jerry

Posting Permissions

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