Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Merger Two Data Sheet | Excel Discussion (Misc queries) | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |