About Us

Don Guillett

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Taking specific rows from on workbook to create another workbook	Michelle	Excel Worksheet Functions	1	May 12th 07 04:54 AM
Excel workbook is corrupted, workbook automatically saves on start	Paul Gooda	Excel Discussion (Misc queries)	3	September 28th 06 04:51 PM
Copy Data from Workbook into specific Worksheet in other Workbook?	kingdt	Excel Discussion (Misc queries)	1	March 16th 06 06:55 PM
Select sheet tabs in workbook & save to separate workbook files	stratocaster	Excel Worksheet Functions	2	March 1st 06 03:35 PM
Multiple workbook user's with Master workbook - all password protected	Yvon	Excel Discussion (Misc queries)	2	March 30th 05 01:34 PM

Menu

About Us