Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking excel spreadsheets into Word
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. -- Barb |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Linking excel spreadsheets into Word
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 "Barbara" wrote: 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. -- Barb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking Excel Spreadsheets in a Notes Database (TeamRoom) | Excel Discussion (Misc queries) | |||
Linking spreadsheets within excel | Excel Discussion (Misc queries) | |||
Linking Spreadsheets in Excel. | Excel Discussion (Misc queries) | |||
how to link excel spreadsheets that are embedded in word | Excel Discussion (Misc queries) | |||
Print errors with Word documents in Excel spreadsheets | Excel Discussion (Misc queries) |