Compress Large Worksheets

  • Thread starter Dale Hildebrand
  • Start date
D

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.
 
C

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
 
Top