G
Guest
I have embedded several excel charts in MS Word. This is done by copying the Excel chart and then using the "paste special" option and choosing to paste it as an embedded object (not a link). I have had to do this for various formatting reasons and pasting it as a picture or a link caused too much time going back to excel to re-format so it would look good in Word. Now in word when you double click on the chart you can edit it just like if it was still in excel
The problem (as I am sure you all will guess) is that the files in Word get very large. If the excel file from which a graph was inserted had 10 other graphs, all are inserted. And if there was 40,000 rows of data, they are all inserted too. I have gone to each of about 35 charts in the Word document and deleted all other charts and unnecessary worksheets but this reduced the file size by less than 1%. Does anyone know why this had such a small effect? If I remove 20 or 30 thousand rows of data (all data except for what is needed for that one particular chart) from every embedded chart, why is there not a more noticeable reduction in file size?
The problem (as I am sure you all will guess) is that the files in Word get very large. If the excel file from which a graph was inserted had 10 other graphs, all are inserted. And if there was 40,000 rows of data, they are all inserted too. I have gone to each of about 35 charts in the Word document and deleted all other charts and unnecessary worksheets but this reduced the file size by less than 1%. Does anyone know why this had such a small effect? If I remove 20 or 30 thousand rows of data (all data except for what is needed for that one particular chart) from every embedded chart, why is there not a more noticeable reduction in file size?