Formatting Lost When You Update a Linked Spreadsheet
  
PSS ID Number: Q111084
Article last modified on 11-03-1994
 
6.00
 
MS-DOS
 

-------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Word for MS-DOS, version 6.0
-------------------------------------------------------------------
 
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.