Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Word

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 04-02-2014, 07:19 PM
Matt.M Matt.M is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Apr 2014
Posts: 2
Matt.M is on a distinguished road
Default Copying excel charts into word - huge file size.

Hi there,
I have a very frustrating situation.

At work I created a word document that I pasted 15 excel charts and 4 photos into. This was when we had Office 2000 (It was back in 2012 – yes, still using it back then). The file size was 1.54MB.



Last year we upgraded to Office 2010. I am now writing a new document that contains pretty much the same excel charts. Now when I paste them in using the same method (paste as enhanced metafile), the file size is a whopping 16MB after only pasting in 12 charts.

When I change the file extension to .zip (for both files - I converted the old .doc to .docx so I could) and open them up, I can see the picture files and in the new document most charts are 5MB, with a couple at 17MB!!. In the old file they are only 120 KB. When you open the emf pictures in paint, the ones from the old file are much smaller in physical size than the new ones.

It seems as if Word 2010 is pasting the charts from excel as huge pictures compared to the old word (or is it excel copying them larger??)

So, is there a way of making them smaller. I have tried all the past as types – png made the smallest file size, but the quality was crap. Why did it used to work brilliantly in Word/Excel 2000 and is so ridiculous in Word/Excel 2010?

Any suggestions or do I just have to live with it?
Reply With Quote
  #2  
Old 04-02-2014, 07:30 PM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 18,460
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

When you paste an Excel chart into Word, you get the Excel workbook too. That's why each one's so large. If you paste as links or as pictures, the increase will be much less. You can minimise the increase with Chart objects by creating the charts from workbooks containing only the charts and the data they rely on, rather than from workbooks that contain lots of extra data, formulae, worksheets, charts, etc.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #3  
Old 04-02-2014, 07:38 PM
Matt.M Matt.M is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Apr 2014
Posts: 2
Matt.M is on a distinguished road
Default

Yes, I know, that is why I always paste as: Picture(enhanced metafile). As I said in original post, I am pasting the same way in both Word 2000 and Word 2010.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for Copying Charts to Powerpoint bremen22 Excel Programming 1 10-01-2013 03:27 PM
Copying a variable size table from Excel via VBA -=bb=- PowerPoint 13 06-05-2013 09:01 AM
Huge file size cns Word 1 01-23-2013 09:40 AM
Embedding Excel charts in PPT or Word Tonto Excel 2 01-05-2011 02:19 PM
My Word File is HUGE bcng4db Drawing and Graphics 0 12-22-2009 01:38 PM


All times are GMT -7. The time now is 10:16 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft