One of the things I found that can adversely affect the size of a WS is the
number of "broken" external links. It can easily happen if it is a sheet
that contains External Links and gets passed around a lot. In 2003, the Name
Manager Addon was very helpful in identifying these rogue links. Not sure
how in 2007 though ..

Also - Pivot Tables use an underlying cache and while the table itself has
low overhead, the cache can be quite expensive. If you have many tables
querying the same data, make sure they all reference the same pivotcache and
that will again reduce the size.

HTH
Regards,
Bony

"Jim" wrote:

I add and delete numerous lines to a workbook every day. Although the actual
updated visiable file should be relatively small (~35K), it keeps growing
daily apparently holding on to deleted (not visable) rows until its size is
350M (10,000 times larger) and it comes to a crawl to update. How do I keep
the size managable.

Thank you