Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Updating Calculations in Word (Word 2003)

    When I try to make a calculated field in Word, the field with the calculation does not update automatically unless I have a very simple table to add things in the same column (SUM(ABOVE.)) How can I get that calculated field to update on a simple form where 2 fields are multiplied then that product is multiplied by a third field. The calculation is (RatePerHour*WorkHoursPerWeek)*No.OfWeeks.) I am sending the form I use as an attachment.
    Attached Files Attached Files

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Updating Calculations in Word (Word 2003)

    Unlike Excel formulas (formulae?), Word fields do not automatically update when something they point to has changed. To update fields, click in the field and press F9, or if you have multiple fields, select the area (or select all) and press F9.

    There is an option to have all fields in the document update when you Print or Print Preview. This is under Tools>Options..., Print tab. If this is turned off, fields in headers and footer still update, but those in the body might not.

  3. #3
    New Lounger
    Join Date
    Sep 2006
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Updating Calculations in Word (Word 2003)

    Is that an issue that people generally get annoyed with? I have read somewhere that the old versions of Word (6.0?) updated calculated fields automatically but that functionality was taken away in Office 97. It seems like a step backwards but maybe there is a very good reason that more seasoned cpu users would understand that I don't? Also is there a way to copy/paste cells with functions from Excel to Word?

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Updating Calculations in Word (Word 2003)

    Word 6 for DOS? I don't remember that far back, I was a WordPerfect user prior to Word 2.0c for Windows... and I don't remember that or Word 95 very well any more. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    Anyway, I don't recall a major change in behavior. At some point there was a security exploit which involved using a field to import a file from disk without any visible indication of what happened. The fix for this probably was specific to the fields that were involved in that little trick.

    > Also is there a way to copy/paste cells with functions from Excel to Word?

    Not sure what you mean here. You can embed an Excel workbook into a Word document. Whether it can be appear to be a single cell, I don't know. This is not a feature that I use.

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

    Re: Updating Calculations in Word (Word 2003)

    Unprotect the document.
    Double click each of the three formfields that contributes to the result (RPH, WHPW and NOW) in turn, tick the "Calculate on exit" check box, then click OK.
    Protect the document for forms.
    As you tab out of the formfields after editing them, the calculated field will be updated automatically.

Posting Permissions

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