Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Thumbs down

    Hello,

    Attached is the ‘challenging’ file.

    I’m not sure why, but none of the auto-calculations of Excel are working!

    First to give an overview of the file:

    - This is a project plan you can use to track project progress
    - Each task has a weight (weights must total 100)
    - Once we enter the ‘% complete’, it should auto-calculate the ‘total’
    - The ‘Overall progress’ (cell # C3) totals all of the Totals from column H

    Here’re the problems:

    - If you update the % Complete, it does not update the Total (column H)
    - The ‘Overall progress’ (cell # C3) does not auto-update if the Totals change
    - If you update the Weights, their total does not update (cell f13)

    Please help!!!! Thanks.

    Alex
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Automatic calculation has been turned off in this workbook. To turn it on:

    - Click the Office button.
    - Select Excel Options.
    - Select Formulas
    - Select Automatic in the Calculation Options section.
    - Click OK.

  3. #3
    New Lounger
    Join Date
    Jun 2009
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Hans; it worked

Posting Permissions

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