ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel link to work can't get full worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/53309-excel-link-work-cant-get-full-worksheet.html)

Tom

excel link to work can't get full worksheet
 
When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.


FinRazel

excel link to work can't get full worksheet
 
How big is the spreadsheet you are trying to paste?

"Tom" wrote:

When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.


Tom

excel link to work can't get full worksheet
 
158 rows by 5 columns....single spreadsheet/worksheet

"FinRazel" wrote:

How big is the spreadsheet you are trying to paste?

"Tom" wrote:

When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.


FinRazel

excel link to work can't get full worksheet
 
Try this:

Save and close your Excel worksheet. Close Excel. In Explorer, rightclick
on the file, click Open With-Microsoft Word.

This will tell word to open your file directly, circumventing the need to
Copy-Paste.

"Tom" wrote:

158 rows by 5 columns....single spreadsheet/worksheet

"FinRazel" wrote:

How big is the spreadsheet you are trying to paste?

"Tom" wrote:

When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.


Tom

excel link to work can't get full worksheet
 
That "Works". Thanks


"FinRazel" wrote:

Try this:

Save and close your Excel worksheet. Close Excel. In Explorer, rightclick
on the file, click Open With-Microsoft Word.

This will tell word to open your file directly, circumventing the need to
Copy-Paste.

"Tom" wrote:

158 rows by 5 columns....single spreadsheet/worksheet

"FinRazel" wrote:

How big is the spreadsheet you are trying to paste?

"Tom" wrote:

When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.


SDP

excel link to work can't get full worksheet
 
Are there any other ways to link or embed an Excel spreadsheet in a Word
document, and still be able to see the whole spreadsheet? Opening the
spreadsheet in Word, while useful to some, isn't quite the same as linking or
embedding the spreadsheet in Word.
And, I'm using 2007.
Thanks.

"Tom" wrote:

That "Works". Thanks


"FinRazel" wrote:

Try this:

Save and close your Excel worksheet. Close Excel. In Explorer, rightclick
on the file, click Open With-Microsoft Word.

This will tell word to open your file directly, circumventing the need to
Copy-Paste.

"Tom" wrote:

158 rows by 5 columns....single spreadsheet/worksheet

"FinRazel" wrote:

How big is the spreadsheet you are trying to paste?

"Tom" wrote:

When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.


Ao

excel link to work can't get full worksheet
 
Will the Excel file still be linked to Word?

"FinRazel" wrote:

Try this:

Save and close your Excel worksheet. Close Excel. In Explorer, rightclick
on the file, click Open With-Microsoft Word.

This will tell word to open your file directly, circumventing the need to
Copy-Paste.

"Tom" wrote:

158 rows by 5 columns....single spreadsheet/worksheet

"FinRazel" wrote:

How big is the spreadsheet you are trying to paste?

"Tom" wrote:

When either importing ole or pasting from an Excel Woorkshhet into a Word
doc, only get a portion of the worksheet to show, even if I "copy" the whole
spreadsheet.



All times are GMT +1. The time now is 06:10 AM.

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