Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Data From Excel
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? |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Data From Excel
One thing you can try is in Excel: select the range and then hold Shift
and go to EditCopy As Picture. Then go into your Word document and simply Paste. HTH Ed sp3cialist wrote: 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? |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Data From Excel
Hi ?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 :-) |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Data From Excel
Thanks, it says it will be truncated..
"Ed" wrote: One thing you can try is in Excel: select the range and then hold Shift and go to EditCopy As Picture. Then go into your Word document and simply Paste. HTH Ed sp3cialist wrote: 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? |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Importing Data From Excel
Thanks, that is what I did in order to resolve.
"Cindy M -WordMVP-" wrote: Hi ?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 :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing web data to Excel | New Users | |||
Importing separate rows of Excel data into single Word templates | Microsoft Word Help | |||
importing data from excel into word documnet | Tables | |||
Importing data from excel into word | Microsoft Word Help | |||
Word Field Codes in Excel data file | Mailmerge |