|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
|
Thread Tools | Display Modes |
|
#1
February 8th, 2008, 03:20 PM
posted to microsoft.public.word.tables
|
|||
|
|||
From Excel to Word
Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table.
However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big? 
|
|
#2
February 8th, 2008, 03:40 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
What versions of Word are you using?
Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
#3
February 8th, 2008, 04:26 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
Office 2002.
"Beth Melton" wrote: What versions of Word are you using? Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
#4
February 8th, 2008, 04:34 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
By the way, you might be raising an issue. The Excel file that I am using is
supplied to me by a customer, and I have no idea what that person's Excel version might be. "Mike" wrote: Office 2002. "Beth Melton" wrote: What versions of Word are you using? Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
#5
February 8th, 2008, 06:16 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
First go to File/Properties and on the Summary tab, make sure "Save Preview
Picture" isn't selected. If the embedded Excel object appears on the first page and is part of the preview picture saved with the file then that's the likely cause of the file bloat you are encountering. IIRC, this was more of an issue in Word 2002 than in other versions which is why knowing which version you are using is helpful information. :-) Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Office 2002. "Beth Melton" wrote: What versions of Word are you using? "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
#6
February 8th, 2008, 07:53 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
Thank you, Beth, for your kind assistance. I do appreciate it.
That box was not checked, so that is probably not the cause. Might there be some other hidden commands that might cause this? "Beth Melton" wrote: First go to File/Properties and on the Summary tab, make sure "Save Preview Picture" isn't selected. If the embedded Excel object appears on the first page and is part of the preview picture saved with the file then that's the likely cause of the file bloat you are encountering. IIRC, this was more of an issue in Word 2002 than in other versions which is why knowing which version you are using is helpful information. :-) Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Office 2002. "Beth Melton" wrote: What versions of Word are you using? "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
#7
February 8th, 2008, 10:03 PM
|
|||
|
|||
|
Quote:
__________________
Henk van Ekelenburg co-author of the eBook "Mastering Microsoft Word for Scientific Reports" (and other long documents) www.masteringword.eu/?Off
|
|
#8
February 9th, 2008, 04:07 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
Do you encounter the same results if you paste it in a new document? Also,
what are the exact steps you are using to copy/paste? Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Thank you, Beth, for your kind assistance. I do appreciate it. That box was not checked, so that is probably not the cause. Might there be some other hidden commands that might cause this? "Beth Melton" wrote: First go to File/Properties and on the Summary tab, make sure "Save Preview Picture" isn't selected. If the embedded Excel object appears on the first page and is part of the preview picture saved with the file then that's the likely cause of the file bloat you are encountering. IIRC, this was more of an issue in Word 2002 than in other versions which is why knowing which version you are using is helpful information. :-) "Mike" wrote in message ... Office 2002. "Beth Melton" wrote: What versions of Word are you using? "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
#9
February 11th, 2008, 03:22 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
I select A1 then scroll down to D3636 and copy. I open a brand new Word file
and create a table with 4 columns and 3636 rows, select the the table in the same way I did the Excel cells and paste. I thought there might be some embedded commands or something in Excel that was causing this bloat or something else I could turn off. Something strange is going on moving from 367K to 5.7M. "Beth Melton" wrote: Do you encounter the same results if you paste it in a new document? Also, what are the exact steps you are using to copy/paste? Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Thank you, Beth, for your kind assistance. I do appreciate it. That box was not checked, so that is probably not the cause. Might there be some other hidden commands that might cause this? "Beth Melton" wrote: First go to File/Properties and on the Summary tab, make sure "Save Preview Picture" isn't selected. If the embedded Excel object appears on the first page and is part of the preview picture saved with the file then that's the likely cause of the file bloat you are encountering. IIRC, this was more of an issue in Word 2002 than in other versions which is why knowing which version you are using is helpful information. :-) "Mike" wrote in message ... Office 2002. "Beth Melton" wrote: What versions of Word are you using? "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
#10
February 12th, 2008, 07:41 PM
posted to microsoft.public.word.tables
|
|||
|
|||
|
From Excel to Word
I fired up an old laptop with Word 2002 and tried it and my results were
similar: a new blank Word document with 3600 rows of Excel data containing numbers only (default formatting), resulted in a 3.75 MB file size. I don't know what your Excel data consists of so that may account for the difference in file size. Pasting the Excel data in the document, instead of inserting a Word table first, may decrease the file size slightly. I didn't test this since Word kept locking up on me pasting only 1000 rows at a time so it took awhile to even get my first test accomplished. (There's a reason why it's my old laptop. grin) I don't know if this helps much but it does appear I'm able to duplicate what you are encountering. Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... I select A1 then scroll down to D3636 and copy. I open a brand new Word file and create a table with 4 columns and 3636 rows, select the the table in the same way I did the Excel cells and paste. I thought there might be some embedded commands or something in Excel that was causing this bloat or something else I could turn off. Something strange is going on moving from 367K to 5.7M. "Beth Melton" wrote: Do you encounter the same results if you paste it in a new document? Also, what are the exact steps you are using to copy/paste? Please post all follow-up questions to the newsgroup. Requests for assistance by email cannot be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Coauthor of Word 2007 Inside Out: http://www.microsoft.com/MSPress/boo...x#AboutTheBook Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Mike" wrote in message ... Thank you, Beth, for your kind assistance. I do appreciate it. That box was not checked, so that is probably not the cause. Might there be some other hidden commands that might cause this? "Beth Melton" wrote: First go to File/Properties and on the Summary tab, make sure "Save Preview Picture" isn't selected. If the embedded Excel object appears on the first page and is part of the preview picture saved with the file then that's the likely cause of the file bloat you are encountering. IIRC, this was more of an issue in Word 2002 than in other versions which is why knowing which version you are using is helpful information. :-) "Mike" wrote in message ... Office 2002. "Beth Melton" wrote: What versions of Word are you using? "Mike" wrote in message ... Hello, I am trying to paste a 4 x 3636 table from Excel into a Word table. However, the size jumps from 365Kb to 5.7 Mb. Why is it growing THAT big?
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
