Importing Data From Excel

[Guest]

Is it possible to copy data from Excel into Word without it cutting off
information, I think there maybe a limit to what you can copy, I have a
worksheet that spans across columns A-R, I have now managed to reduce the
column sizes and it seems to copy them but anything more than this gets cut
off. Also it goes down to row 82 and it can't seem to cope with it and only
copies 57 rows.

I have done Copy and Paste Special (As Excel Object) I have also done it as
a picture, also tried using insert, file and insert, object and insert
picture.

Is there anyway of doing it? Does anyone know the limits?

 

[Ed]

One thing you can try is in Excel: select the range and then hold Shift
and go to Edit>>Copy As Picture. Then go into your Word document and
simply Paste.

HTH
Ed

 

[Ed]

One thing you can try is in Excel: select the range and then hold Shift
and go to Edit>>Copy As Picture. Then go into your Word document and
simply Paste.

HTH
Ed

 

[Cindy M -WordMVP-]

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

Is it possible to copy data from Excel into Word without it cutting off
information, I think there maybe a limit to what you can copy, I have a
worksheet that spans across columns A-R, I have now managed to reduce the
column sizes and it seems to copy them but anything more than this gets cut
off. Also it goes down to row 82 and it can't seem to cope with it and only
copies 57 rows.

I have done Copy and Paste Special (As Excel Object) I have also done it as
a picture, also tried using insert, file and insert, object and insert
picture.

Is there anyway of doing it? Does anyone know the limits?

Prior to Word 2002 there are definitely limits, although I no longer remember
exactly what they are. Internally, Word calculates what "should be able to
fit" on a single page, and cuts off based on that. doesn't matter if it really
would fit, and there's no way to change it. The only workaround I know of is
to copy/paste two or more sets and position them adjacent to one another.

In Office XP Microsoft changed the algorithm so that Word automatically cuts
the zoom by 50% as soon as what's pasted is too large.

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

 

[Cindy M -WordMVP-]

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

Is it possible to copy data from Excel into Word without it cutting off
information, I think there maybe a limit to what you can copy, I have a
worksheet that spans across columns A-R, I have now managed to reduce the
column sizes and it seems to copy them but anything more than this gets cut
off. Also it goes down to row 82 and it can't seem to cope with it and only
copies 57 rows.

I have done Copy and Paste Special (As Excel Object) I have also done it as
a picture, also tried using insert, file and insert, object and insert
picture.

Is there anyway of doing it? Does anyone know the limits?

Prior to Word 2002 there are definitely limits, although I no longer remember
exactly what they are. Internally, Word calculates what "should be able to
fit" on a single page, and cuts off based on that. doesn't matter if it really
would fit, and there's no way to change it. The only workaround I know of is
to copy/paste two or more sets and position them adjacent to one another.

In Office XP Microsoft changed the algorithm so that Word automatically cuts
the zoom by 50% as soon as what's pasted is too large.

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

 

[Guest]

Thanks, it says it will be truncated..

One thing you can try is in Excel: select the range and then hold Shift
and go to Edit>>Copy As Picture. Then go into your Word document and
simply Paste.

HTH
Ed

 

[Guest]

Thanks, it says it will be truncated..

One thing you can try is in Excel: select the range and then hold Shift
and go to Edit>>Copy As Picture. Then go into your Word document and
simply Paste.

HTH
Ed

 

[Guest]

Thanks, that is what I did in order to resolve.

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

Prior to Word 2002 there are definitely limits, although I no longer remember
exactly what they are. Internally, Word calculates what "should be able to
fit" on a single page, and cuts off based on that. doesn't matter if it really
would fit, and there's no way to change it. The only workaround I know of is
to copy/paste two or more sets and position them adjacent to one another.

In Office XP Microsoft changed the algorithm so that Word automatically cuts
the zoom by 50% as soon as what's pasted is too large.

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

 

[Guest]

Thanks, that is what I did in order to resolve.

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

Prior to Word 2002 there are definitely limits, although I no longer remember
exactly what they are. Internally, Word calculates what "should be able to
fit" on a single page, and cuts off based on that. doesn't matter if it really
would fit, and there's no way to change it. The only workaround I know of is
to copy/paste two or more sets and position them adjacent to one another.

In Office XP Microsoft changed the algorithm so that Word automatically cuts
the zoom by 50% as soon as what's pasted is too large.

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