Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Object
I am trying to insert the contents of a 2 page Word File into an Excel
Worksheet using Insert Object but only the first page of the document appears in the Excel Worksheet. Anyone help? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Object
An inserted object cannot span more than one page. A workaround is to
open the Word document in Word, select and copy the first page, paste it into Excel as a Word object by clicking on Edit | Paste Special | Paste as: Word object | OK, select and copy the second page in Word, and paste the second page into Excel as a Word object. The disadvantage of this method is that the entire Word file is embedded into Excel each time you paste as an object, even though only one page shows, so the size of your Excel file will increase. SS wrote: I am trying to insert the contents of a 2 page Word File into an Excel Worksheet using Insert Object but only the first page of the document appears in the Excel Worksheet. Anyone help? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert Object
Thanks :~}
"garfield-n-odie [MVP]" wrote: An inserted object cannot span more than one page. A workaround is to open the Word document in Word, select and copy the first page, paste it into Excel as a Word object by clicking on Edit | Paste Special | Paste as: Word object | OK, select and copy the second page in Word, and paste the second page into Excel as a Word object. The disadvantage of this method is that the entire Word file is embedded into Excel each time you paste as an object, even though only one page shows, so the size of your Excel file will increase. SS wrote: I am trying to insert the contents of a 2 page Word File into an Excel Worksheet using Insert Object but only the first page of the document appears in the Excel Worksheet. Anyone help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert object problem | Excel Discussion (Misc queries) | |||
Can't insert the object | Excel Discussion (Misc queries) | |||
Insert Object | Excel Discussion (Misc queries) | |||
can not insert object | Excel Worksheet Functions | |||
Cannot insert object | Excel Discussion (Misc queries) |