Huge spreadsheets, anything I can do?
 

I have a workbook that contains nothing but a dozen sheets with a
single string typed into A1 of each sheet. A large VBA macro opens the
book, looks at A1, then runs a big macro to fill in details in a big
dense chunk of data. Most of the resulting sheets are less than 500
rows long, only one is larger at about 1500 rows. They are about 100
columns wide, but most of these are static numbers.

The original book is 57k on disk. After populating and saving, it's
9000k on disk. ZIPing the result makes it under 2000k. Is there
something I can do in Excel 2003 to make these files smaller without
ZIPing?

In case you're wondering: we often e-mail these around, and most e-
mail filters chop off anything WAY smaller than this. It's a real
problem.

Maury

Huge spreadsheets, anything I can do?
 

On a sheet in this workbook where does CTRL + End take you?

If far below or right of apparent used range..............

See Debra Dalgleish's site for info on trimming large workshets/books.

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


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 11:39:24 -0700 (PDT), Maury Markowitz
wrote:

I have a workbook that contains nothing but a dozen sheets with a
single string typed into A1 of each sheet. A large VBA macro opens the
book, looks at A1, then runs a big macro to fill in details in a big
dense chunk of data. Most of the resulting sheets are less than 500
rows long, only one is larger at about 1500 rows. They are about 100
columns wide, but most of these are static numbers.

The original book is 57k on disk. After populating and saving, it's
9000k on disk. ZIPing the result makes it under 2000k. Is there
something I can do in Excel 2003 to make these files smaller without
ZIPing?

In case you're wondering: we often e-mail these around, and most e-
mail filters chop off anything WAY smaller than this. It's a real
problem.

Maury