G
Guest
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.
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.