Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Resize linked Excel spreadsheet within Word
I have pasted a spreadsheet into Word. The page layout is legal. The
spreadsheet has to be resized in the document to fit the page. When I go to links and click manual update, the spreadsheet grows and doesn't fit the page. If I try to resize it again all of the spreadsheet isn't there. I need the link set to manual and the spreadsheet size to stay the same. Using Word and Excel 2003 SP3. How can I accomplish this? Thanks |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Resize linked Excel spreadsheet within Word
Hi ?B?Ulc=?=,
I have pasted a spreadsheet into Word. The page layout is legal. The spreadsheet has to be resized in the document to fit the page. When I go to links and click manual update, the spreadsheet grows and doesn't fit the page. If I try to resize it again all of the spreadsheet isn't there. I need the link set to manual and the spreadsheet size to stay the same. Using Word and Excel 2003 SP3. How can I accomplish this? Links in Word are managed by fields. If you press Alt+F9 you toggle the field codes/display in the document. What do you see between the { field brackets } of the field for the Excel sheet? If it contains \a try deleting those characters from the field code. They're responsible for controlling the automatic update. Perhaps removing them manually from the field, rather than going over the dialog box, will keep the table size stable. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Resize linked Excel spreadsheet within Word
That appears to have worked. Thanks!!
"Cindy M." wrote: Hi ?B?Ulc=?=, I have pasted a spreadsheet into Word. The page layout is legal. The spreadsheet has to be resized in the document to fit the page. When I go to links and click manual update, the spreadsheet grows and doesn't fit the page. If I try to resize it again all of the spreadsheet isn't there. I need the link set to manual and the spreadsheet size to stay the same. Using Word and Excel 2003 SP3. How can I accomplish this? Links in Word are managed by fields. If you press Alt+F9 you toggle the field codes/display in the document. What do you see between the { field brackets } of the field for the Excel sheet? If it contains \a try deleting those characters from the field code. They're responsible for controlling the automatic update. Perhaps removing them manually from the field, rather than going over the dialog box, will keep the table size stable. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I insert an Excel table in Word, then resize it to fit? | Tables | |||
Adding a page break to a Word doc with an Excel spreadsheet linked | Microsoft Word Help | |||
excel--to-excel linked cells not updated in word mailmerge | Mailmerge | |||
Locked Form with Linked Spreadsheet | Tables | |||
Problems opening linked Excel spreadsheet in Word 2003 | Microsoft Word Help |