Thursday, May 21, 2009

Strange Behavior of Excel - Reduce Size of Multiple Embedded Documents in Excel

Today, when I working on a excel document, I happened to embed a word document multiple times. I deleted it, emded it again, and it went on for several times. I noticed that this increases the size of the Excel. Whenever the embedded document is deleted from excel, then excel just removes the reference and leaves the contents of the embedded document hidden. This increases the size of the excel. I couldnt find how to reduce the size of the excel. Only thing which worked was copy the contents of the excel and paste in a new excel. In this way, the size reduces considerably.