INVCE.DOT in Word Developer's Kit Displays Incorrect Results

 Last reviewed: February 5, 1998
Article ID: Q115788

The information in this article applies to:
  • Microsoft Word for Windows, versions 6.0, 6.0a
  • Microsoft Windows operating system version 3.1

SYMPTOMS

The invoice example template (INVCE.DOT) in the Word Developer's Kit displays incorrect results for the Amount field in the third line, the TOTAL field, and the Balance Due field.

CAUSE

These calculation fields contain incorrect cell references.

RESOLUTION

Use the following steps to correct the formulas in the INVCE.DOT template.

  1. Open INVCE.DOT (usually found in the C:\WINWORD\TEMPLATE subdirectory).

  2. From the Tools menu, choose Unprotect Document.

  3. Double-click the third Amount field.

  4. In the Expression field, change "A3" to "A4" (without the quotation marks). Choose OK.

  5. Double-click the TOTAL field.

  6. In the Expression field, change "B10,B11" to "B1,B2" (without the quotation marks). Choose OK.

  7. Double-click the Balance Due field.

  8. In the Expression field, change "B12 - B13" to "B3 - B4" (without the quotation marks).

  9. From the Tools menu, choose Protect Document.

  10. Select the Forms option button and choose OK.

  11. Save and close the template.

KBCategory: kbusage
KBSubcategory: kbtemplate
Additional reference words: 6.0 6.0a incorrect wrong error formula field
word6 values winword
Keywords : kbtemplate
Version : 6.0 6.0a
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: February 5, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.