Have used previous versions of Excel w/o issues, but 2010 is another story. A spreadsheet is used as an inspection report file...shared by users across computers at different locations, so no common folder in which to store pics and link, so picture has to be inserted as an object...considering Windows Live SkyDrive, among others as a long term solution. BUT FOR NOW:
Adding pictures to an Excel 2010 workbook, even using picture compression, adds an extreme amount of file bloat:
Test: Excel 2000 Excel 2003 Excel 2007 Excel 2010
Empty SpreadSheet 13,824 13,824 15,360 22,013 54%
1 (408K) pic 423,424 423,424 427,008 22,528
(link in 2010)
2010: Insert pic as object n/a n/a n/a 4,209,664 891%
2010: Compress object pic 1,825,792 330%
(to 96 ppi)
Couldn't find any reasons why, or methods to reduce file size, on web.
Anybody have any suggestions?