Compress Large Worksheets

[Dale Hildebrand]

Sometimes Excel appears to assume that a spreadsheet is
much larger than required, i.e., only has data in first
100 rows, yet Ctrl-End takes you to row 1,000. We have an
spreadsheet that is over 20 MB in size and is very slow to
re-calculate. If there a way to remove the "dead space"
and will this improve the performance? Thanks.

 

[jammy]

http://www.mvps.org/dmcritchie/excel/slowresp.htm

might help

 

[Charles Williams]

Hi Dale,

The simplest method is to delete all the rows from 101 to 65536 and save as
a different name. (repeat for columns if required).
This works under most circumstances, but will alter any formulae that refer
to the deleted rows/columns, so use with care.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com

 

[Dave Peterson]

Debra Dalgleish has some notes and pictures at:
http://www.contextures.com/xlfaqApp.html#Unused