Resize linked Excel spreadsheet within Word

[RW]

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

 

[Cindy M.]

Hi =?Utf-8?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

 

[RW]

That appears to have worked. Thanks!!

Hi =?Utf-8?B?Ulc=?=,

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)


This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail