Increasing file sizes when deleting formulae

  • Thread starter Thread starter Thommo
  • Start date Start date
T

Thommo

Does anyone know why a file starting at about 15MB
increases (almost doubles) in size when deleting a column
containing a simple formula (there are about 700 rows of
data)? The subsequent columns (about 200) contain more
complex formulae, but nothing Earth-shattering and Excel
tells me as it recalculates the cells afterwards without
apparent problem.

Any help would be appreciated!
 
I am not sure if this is much help, but I'll post it anyway.

I have had a similair problem with a file that was approx 30MB. Afte
deleting alot of data, formulas and macros the file size increased t
over 50MB.

What I did was copy everything over into a new workbook and the fil
size came down to 15MB.

I guess its a problem in excel somewhere
 
Back
Top