Microsoft KB Archive/111084

Formatting Lost When You Update a Linked Spreadsheet

PSS ID Number: Q111084 Article last modified on 11-03-1994

6.00

MS-DOS

= SYMPTOMS =

If you update a linked spreadsheet in your Word for MS-DOS document, any formatting you applied to the inserted data is lost. Lost formatting includes table borders, column width, and row height settings, and character and paragraph formatting.

= CAUSE =

This problem occurs if you insert the spreadsheet in Word as a table. When you update such a link, Word deletes the table and replaces it with a new table and the updated data from the spreadsheet.

= STATUS =

Microsoft has confirmed this to be a problem in Word 6.0 for MS-DOS. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

= WORKAROUND =

To maintain the formatting you apply to a linked spreadsheet, insert the spreadsheet as a tab-delimited paragraph. (This is similar to the method you use in Word 5.5.) To do this, clear the Insert Spreadsheet As Table check box in the Tools Customize dialog box.

= MORE INFORMATION =

Page 580 in “Using Microsoft Word” incorrectly states that “…any paragraph formatting …or styles you’ve applied to the paragraph are reapplied to the new data.”

This passage should state that for this to work correctly, you must insert the spreadsheet as paragraphs instead of as a table.

= REFERENCES =

“Using Microsoft Word,” version 6.0, page 580

KBCategory: kbother KBSubcategory: Additional reference words: 6.00 wdformat

=
================================================================ Copyright Microsoft Corporation 1994.