Help! My Workbook is HUGE!

[Tia]

I have a workbook with 9 worksheets. I've followed the instructions from the
following link: http://contextures.com/xlfaqApp.html#Unused. However, I
still have all of the rows below my data. Is there another way to delete
unused rows? Or do I need to check to see if there is data hidden in the
rows? I'm at a loss. It takes forever to open the workbook, save or make
changes.

Thanks for any advice.

 

[JP]

Those empty rows will not disappear. If your workbook has a lot of
formulas (esp array formulas), formatting, fonts, etc, you may hit
Excel's dependency limit.

Check out
http://www.decisionmodels.com/calcsecretsd.htm
for more info

You should press Ctrl-End on each worksheet, then highlight ALL empty
rows/columns to the right & bottom of your data, hit Save and repeat
until all worksheets are cleaned. Close and reopen file.

If that still doesn't work, consider rebuilding/recreating your
workbook from scratch. You can cut and paste the data from each
worksheet into new worksheets in a new workbook, this should solve
some of your problems.

HTH,
JP

 

[Jim Thomlinson]

Once you deleted the rows did you save the workbook. The size will not
decrease until you do.