Thread
:
how to unbloat a workbook?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett