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

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

how to unbloat a workbook?
 

Don- thank you for your reply. The large filesize entry in the link appears
to be related to used/unused cells at the bottom (or right) of ranges, and
I've deleted those rows/columns to no effect.

I'm thinking that I need to somehow export/import each sheet (or something
like that) to clean the workbook, but I don't know enough about the inner
workings of Excel 2003 to know if that will actually help, and whether I
risk breaking links and affecting named ranges by doing so. I don't have a
lot of formatting in my workbook, just a few columns where all cells in the
column have the same conditional formatting.

To adapt your other suggestion (instead of replicating everything in VBA) I
left an example formula in the cell at the top of each column, and
pastespecial/values for the rest of each column, thereby eliminating a lot
of the (repetitive) formulas. If I need to see the formula to know how the
data was calculated, or modify it, I can use that formula cell again. This
made a phenominal difference; the workbook went from 11MB to 7MB with just
that one change!

I think that 7MB is still incredibly large for the amount of data I have in
the workbook- I'd have expected it to be closer to 2MB- so I'm open to any
other suggestions.

Thanks!
Keith

"Don Guillett" wrote in message
...
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

how to unbloat a workbook?
 

If you want to send it, I will take a look.

--
Don Guillett
SalesAid Software

"Keith R" wrote in message
...
Don- thank you for your reply. The large filesize entry in the link
appears to be related to used/unused cells at the bottom (or right) of
ranges, and I've deleted those rows/columns to no effect.

I'm thinking that I need to somehow export/import each sheet (or something
like that) to clean the workbook, but I don't know enough about the inner
workings of Excel 2003 to know if that will actually help, and whether I
risk breaking links and affecting named ranges by doing so. I don't have a
lot of formatting in my workbook, just a few columns where all cells in
the column have the same conditional formatting.

To adapt your other suggestion (instead of replicating everything in VBA)
I left an example formula in the cell at the top of each column, and
pastespecial/values for the rest of each column, thereby eliminating a lot
of the (repetitive) formulas. If I need to see the formula to know how the
data was calculated, or modify it, I can use that formula cell again. This
made a phenominal difference; the workbook went from 11MB to 7MB with just
that one change!

I think that 7MB is still incredibly large for the amount of data I have
in the workbook- I'd have expected it to be closer to 2MB- so I'm open to
any other suggestions.

Thanks!
Keith

"Don Guillett" wrote in message
...
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