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.

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

On Mar 17, 5:02*pm, Tia wrote:
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.

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

Jim Thomlinson


"Tia" wrote:

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.