Hey Steve,

Just tried it and it's not exactly what I'm looking for. I have a worksheet that has a bunch of objects (346) that were added from the control toolbox. I can delete the shapes easily, but it doesn't help so much with the size. I guess now I'm just looking for the reason this file is 10MB. It only has 6000 rows of data and all the other worksheets are simply pivot tables of the main sheet.

I copied the main worksheet into a new book and the book is 3MB as a result...so where does the 7MB come from?

Thanks for the code. I'll remember it for future reference.