Huge spreadsheets, anything I can do?

[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

 

[Gord Dibben]

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

 

[Maury Markowitz]

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

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

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