Grant Gamble reports that after creating a Word file with an embedded spreadsheet charts in Windows and moving it the Mac, the file size can increase ten-fold after making small edits:
I created a Word file on my MacBook Pro (Aluminum unibody) through Parallels, Windows Word. The file contains charts special pasted from Excel; which means that these graphs can be edited in Word. My problem is that when I move it to my iMac (email/ USB flash drive etc) and open the file in Mac Word; if I edit the in-Word Excel charts, then the file size balloons. I have templates of these files with different numbers of the same charts in each and one with 12 graphs on my MacBook Pro, is a much smaller file size than the same file, but with only four charts edited on the iMac. All of the charts can be edited on any Windows-based word program, with no file size increase at all. The problem lies somewhere between Windows Word and Mac Word.
To test, I emailed a file containing six charts to my iMac again. Once I had edited four of the charts; the file size had changed from 216kb to 1.8mb. The file sizes continue to increase with bigger jumps each time: four charts edited, 1.8mb. Five charts edited, 2.2mb, Six charts edited, 2.7mb. Each time I edited the charts, I use the same values. The file size should either not change at all, because values are being changed not added, or change by the same amount each time, but nowhere near the large amount it does.
If you've seen this problem
Comment below