Microsoft KB Archive/67684

Word: Importing Spreadsheets that Contain Errors

PSS ID Number: Q67684 Article last modified on 11-02-1994

5.00 5.50 6.00

MS-DOS

= SUMMARY =

After linking to a spreadsheet file that contains cells with errors, such as “#DIV/0,” the errors will appear in Microsoft Word as “!!!” or as the number 8.

If your computer does not have a math coprocessor, linked spreadsheet cells with errors will display as “!!!” (instead of the spreadsheet error message). If a math coprocessor is present, linked cells with errors will display with the number 8 or -8 within Microsoft Word. “!!!” or the number 8 will replace spreadsheet error messages regardless of the spreadsheet file format (Lotus, Multiplan, or Excel).

Microsoft has confirmed this to be a problem with Word versions 5.0 and 5.5. We are researching this problem and will post new information here as it becomes available.

= MORE INFORMATION =

Error messages such as “#DIV/0” or “#ERR1” can appear in the spreadsheet cells as a result of a formula. For more information on spreadsheet errors, refer to the spreadsheet program’s documentation.

KBCategory: kbother kberrmsg KBSubcategory: Additional reference words: 5.00 5.50 6.00 ============================================================================= Copyright Microsoft Corporation 1994.