Huge spreadsheets, anything I can do?

  • Thread starter Thread starter Maury Markowitz
  • Start date Start date
M

Maury Markowitz

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
 
On a sheet in this workbook where does CTRL + End take you?

If far below or right of apparent used range..............
Click to expand...

It depends on the definition of "far". On the "big" example there's
about 1600 rows of data, and it scrolls to line 2120. And that's AFTER
doing the EntireRow.Delete trick!

Maury
 
Back
Top