View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Keith R Keith R is offline
external usenet poster
 
Posts: 55
Default how to unbloat a workbook?

I have a workbook with about 10 graphs, 10-12 named ranges, and several
worksheets with data (many, many formulas).

The workbook is now 11MB, although I don't believe that I have that much
actual content, so I need to unbloat the workbook. I already used Rob Boveys
magnificent code cleaner, but there isn't that much VBA in the file so it
didn't affect the filesize.

Given that I don't want to mess up the named ranges, graphs source
references, and formulas, what is the safest way to "rebuild" an Excel
workbook? (Excel 2003)

Thanks,
Keith