View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default how to unbloat a workbook?

More info here. You probably need to trim past what is needed.
Maybe many of your formulas could also be replaced with macros to leave just
the values?
http://www.contextures.com/tiptech.html


--
Don Guillett
SalesAid Software

"Keith R" wrote in message
...
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