Excel doesn't have a compact and repair option.

But if you hit ctrl-end on a worksheet and go past what you think is the bottom
right corner of your data, you can use some techniques at Debra Dalgleish's
site:

http://contextures.com/xlfaqApp.html#Unused

You can also reduce the size by cleaning the code.

You can Rob Bovey's code cleaner he
http://www.appspro.com/



naiveprogrammer wrote:

I have a workbook that contains 13 sheets with VBA code as well. My file is
rather large as you would expect. I use "Compact & Repair" often in Access
to make my files smaller. Does Excel have anything like this? Or is there a
way to make the file smaller??

Thanks!

--

Dave Peterson