What makes a Large File in Excel?

[Don]

I was working on a file for a friend and when I was finished, the file size
was about 1k. When she did the process, it was over 35k and even had one
file over 128k. I was impressed by the size and I watched her do the
process from scrach, it was 35k again. We are working on only one sheet of
data to copy that is only about 1,800 lines and 46 columns. When I took her
big file that broke and did past onto a new sheet, it was large again so I
had to do past special values then format the columns like dates.

any clue why some Excel Files are large?

 

[Don]

as an fyi - from the large file I deleted the blank lines after the date and
blank columns after the data and the file went from 31mb to 400k. It appears
to have stuff in the blank columns?

 

[Gord Dibben]

See Debra's site for info on large file sizes and how to reset.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP

 

[Don]

thanks, this helped

See Debra's site for info on large file sizes and how to reset.

http://www.contextures.on.ca/xlfaqApp.html#Unused


Gord Dibben MS Excel MVP