Why does my sheet have 60,000 rows when only 60 rows have data?
 

I have a workbook with 9 sheets whose cells get added on a tenth summary
sheet. When I check for the last cell on each sheet using CTL+End, all of
the sheets but one show cell EP61 as the last cell. That one, which is not
the summary sheet, shows the last cell as EP62427. The file size is 4MB
because of this problem. I tried deleting the rows below row 61 but that
didn't work. We need to email this workbook lots of people daily and the
file size is a problem. I could delete the sheet and reformat it but I think
there has to be a better way to fix this.

Why does my sheet have 60,000 rows when only 60 rows have data?
 

Hi Joe

You can find information on this page
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Joe Fuller" <Joe wrote in message ...
I have a workbook with 9 sheets whose cells get added on a tenth summary
sheet. When I check for the last cell on each sheet using CTL+End, all of
the sheets but one show cell EP61 as the last cell. That one, which is not
the summary sheet, shows the last cell as EP62427. The file size is 4MB
because of this problem. I tried deleting the rows below row 61 but that
didn't work. We need to email this workbook lots of people daily and the
file size is a problem. I could delete the sheet and reformat it but I think
there has to be a better way to fix this.