#1
|
|||
|
|||
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? |
#2
|
||||
|
||||
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 [Fmr MS MVP - Word] |
#3
|
|||
|
|||
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.
|
|
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 |