my workbook is too big

  • Thread starter Thread starter spence
  • Start date Start date
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
 
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?
 
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
 
Back
Top