Linking excel spreadsheets into Word

[Guest]

When I link several excel spreadsheets into my Word document (word/excel
2000) they all look great on screen -- spreadsheets followed by paragraphs of
narrative -- but when I print it, some of the spreadsheets migrate to other
places in the document, or totally disappear, or print out distorted beyond
belief (squashed, expanded, unreadable). I did edit paste special as link,
excel worksheet. Is there a way to "lock" them in place, and make them print
appropriately? Default font for Word and Excel both Arial 10 pt.

 

[Guest]

Hi,

There are few things I would like to mention:

1. When you use Paste Special command, the data is stored in the Microsoft
Word document with absolute reference value of the cell location from the
Microsoft Excel sheet. fine.

2. You are just adjusting the layout in your Word document page. Therefore,
what you see is not what you get. You must adjust the page in the Microsoft
Excel to suite you Word document page layout.

Just mere adjusting the layout in the Word does not suffice. Because when
you print the document from Word, the remote reference to source document (in
this case it Microsoft Excel) layout is important.

Word stores the display attribute - that is your customized layout, changed
margins and so on that you have defined, but Excel stores the actual value
and properties of the Cell column and rows marigins.

Important: It is important that the Margins of page in Microsoftsof Excel
matches the Margins of Microsoft Word document. Even if you adjust the word
document, any change in the excel document will have priority during
printing. Any changes in the Excel document will refresh the Word document
and all your formatting will be lost.

Challa Prabhu