my workbook is too big

S

spence

i have a workbook with several sheets of data on it, not
much like 15 columns and 20 rows full of text, columns
are a little wider than normal, but not one over twice
its original size. my main data sheet is a table. i
copied the format of the whole sheet, along with the 1st
row of the sheet to 12 other sheets, so i have 13
identical sheets, but only one has data on it right now.
when i saved it, the workbook was like almost 400k. no
formulas are copied any further down than the 20th row of
the main sheet. i have many macros running on the one
main sheet but thats all, when i added the 12 other
sheets the size skyrocketed. any ideas as to why and
what i might do to reduce its size? TIA
 
S

spence

that helped a little, would a workbook's size increase
that dramatically when i "select all cells" and format
paint to all the other sheets?
 
M

Mike A

Yes, selecting an entire sheet to copy formats will bloat your file.

Instead of copying the format info for 300 cells (15 col X 20 rows),
it copies format info for all 16,777,216 cells (256 col X 65536 rows).
Per sheet.

A user at work made a file go from 43K to 2.7MB this way. To fix it,
I copied the data, one sheet at a time, to a new workbook, selecting
only the used range of each sheet. She hasn't done that again. Live
and learn!!

-Mike

that helped a little, would a workbook's size increase
that dramatically when i "select all cells" and format
paint to all the other sheets?
Click to expand...

Mike Argy
Custom Office Solutions
and Windows/UNIX applications

Please post on-topic responses to the newsgroup

To e-mail me, remove nospam from the address in the headers
 
Top