ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Word Document object in Excel show only 1 page (https://www.excelbanter.com/excel-discussion-misc-queries/149731-word-document-object-excel-show-only-1-page.html)

Cato Larsen

Word Document object in Excel show only 1 page
 
Hey!
I have a user with a problem.
When you insert a word document into excel trough:
Insert-Object-From File-Something.doc

The object will only show the first page of the document instead of showing
the whole document all the way down to the last page as a long strand of
text, tables and images.

An example of this can be seen he http://imajr.com/Excel_Problem_172344

How can this be worked around while still retaining the "link" to the
original document so that changes done in the doc will be reflected in Excel
and vice versa?

In advance, thank you for replying!

Dave Peterson

Word Document object in Excel show only 1 page
 
I don't think you can change this.

But you can double click on that embedded object and you'll see the whole
document.

An alternative that I've used is to create multiple word documents (one page per
document) and embed each.

Cato Larsen wrote:

Hey!
I have a user with a problem.
When you insert a word document into excel trough:
Insert-Object-From File-Something.doc

The object will only show the first page of the document instead of showing
the whole document all the way down to the last page as a long strand of
text, tables and images.

An example of this can be seen he http://imajr.com/Excel_Problem_172344

How can this be worked around while still retaining the "link" to the
original document so that changes done in the doc will be reflected in Excel
and vice versa?

In advance, thank you for replying!


--

Dave Peterson

Cato Larsen

Word Document object in Excel show only 1 page
 
So, is there no way to make the object show more than one page other than to
copypaste the contents of the word file into excel?

Cheers!
--
Cato Larsen
HelpDesk Monkey


"Dave Peterson" wrote:

I don't think you can change this.

But you can double click on that embedded object and you'll see the whole
document.

An alternative that I've used is to create multiple word documents (one page per
document) and embed each.

Cato Larsen wrote:

Hey!
I have a user with a problem.
When you insert a word document into excel trough:
Insert-Object-From File-Something.doc

The object will only show the first page of the document instead of showing
the whole document all the way down to the last page as a long strand of
text, tables and images.

An example of this can be seen he http://imajr.com/Excel_Problem_172344

How can this be worked around while still retaining the "link" to the
original document so that changes done in the doc will be reflected in Excel
and vice versa?

In advance, thank you for replying!


--

Dave Peterson


Dave Peterson

Word Document object in Excel show only 1 page
 
Or double click on it and open it.

Cato Larsen wrote:

So, is there no way to make the object show more than one page other than to
copypaste the contents of the word file into excel?

Cheers!
--
Cato Larsen
HelpDesk Monkey

"Dave Peterson" wrote:

I don't think you can change this.

But you can double click on that embedded object and you'll see the whole
document.

An alternative that I've used is to create multiple word documents (one page per
document) and embed each.

Cato Larsen wrote:

Hey!
I have a user with a problem.
When you insert a word document into excel trough:
Insert-Object-From File-Something.doc

The object will only show the first page of the document instead of showing
the whole document all the way down to the last page as a long strand of
text, tables and images.

An example of this can be seen he http://imajr.com/Excel_Problem_172344

How can this be worked around while still retaining the "link" to the
original document so that changes done in the doc will be reflected in Excel
and vice versa?

In advance, thank you for replying!


--

Dave Peterson


--

Dave Peterson


All times are GMT +1. The time now is 09:02 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com