Linking large objects
in [Document Management]
|
Prev: Convert Wordstar to Word 2007?
Next: Document won't print using show/hide parargraph marks. Blocked?
From: OjiisanHikui on 20 Feb 2010 11:04 I have an Excel 2003 worksheet I'm trying to link into a Word 2003 document. However, only about 1/3 of the worksheet (as much as will show on one page) is showing up. Is there any way to tell Word to show the whole worksheet, even if it's larger than one page?
From: Jay Freedman on 20 Feb 2010 12:48
On Sat, 20 Feb 2010 08:04:01 -0800, OjiisanHikui <OjiisanHikui(a)discussions.microsoft.com> wrote: >I have an Excel 2003 worksheet I'm trying to link into a Word 2003 document. >However, only about 1/3 of the worksheet (as much as will show on one page) >is showing up. Is there any way to tell Word to show the whole worksheet, >even if it's larger than one page? No, Word cannot display more than one page of any object. The problem is with the "object" part. Instead, open the worksheet in Excel, select all the cells you want to show in Word, and copy to the clipboard. Switch to Word, and click Edit > Paste Special. Select the "Paste as link" option and the HTML Format choice, and click OK. -- Regards, Jay Freedman Microsoft Word MVP FAQ: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |