how to unbloat a workbook?

K

Keith R

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
 
K

Keith R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

duplicate named ranges- how to detect, delete? 2
Copying/Linking Entire Workbook 2
Deleting all named ranges that have a workbook scope 3
remove named ranges from formulas?? 2
Filesize: embedded data validation lists all stored independently? 2
Indexing for data found within a Table Query 2
Copy worksheet containing names to other workbook w/o problems? 1
Copying to a new workbook without formulas referencing original wk 1

Top