Microsoft KB Archive/63911

Word: Formatting Lost with Update Spreadsheet Data

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

5.00

MS-DOS

= SUMMARY =

When importing data from a spreadsheet, Word automatically includes special codes (.L.) formatted as hidden text at the beginning and end of the data.

If an imported spreadsheet area is updated, Word will replace everything between the starting and ending .L. codes. Any paragraph formatting or styles applied to the paragraph are reapplied to the new data. Character formatting will be kept only if it is part of an attached style sheet.

However, paragraph formatting, such as tab stops, might be lost if the paragraph symbol that follows the ending code is also formatted as hidden text. To correct this problem, put the cursor on the paragraph symbol and set the Format Character “hidden:” field to No.

KBCategory: kbother KBSubcategory: Additional reference words:

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