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) 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 ****. Why did it used to work brilliantly in Word/Excel 2000 and is so ridiculous in Word/Excel 2010?
Any suggestions? Remember I am doing a copy/paste now as I did with the old version.
