Why has file size jumped in an Excel workbook?
 

I have an excel workbook that started as 148kB and is now 2.6MB, but the size
increase is for no apparent reason, I'm not aware of doing anything other
than forwarding it by email to a colleague. When I check one of the sheets
it shows the last cell to be at row 27364 even though there is nothing beyond
row 26, but I can't seem to clear the range. There are no spurious
characters that I can see, what have I done?

I had this happen when I accidentally applied a format change to the entire
worksheet. Try selecting the entire worksheet, select edit/clear.../formats.

Good luck,
Joe

"Jag Nut" wrote:

I have an excel workbook that started as 148kB and is now 2.6MB, but the size
increase is for no apparent reason, I'm not aware of doing anything other
than forwarding it by email to a colleague. When I check one of the sheets
it shows the last cell to be at row 27364 even though there is nothing beyond
row 26, but I can't seem to clear the range. There are no spurious
characters that I can see, what have I done?

I can't seem to clear the range

You need to delete the extra rows (and /or columns). Simply clearing them
doesn't do what you want.

Select the "extra" rows, right click and select "Delete". Save. Check the
last cell again after you reopen the book (sometimes reopening isn't
necessary depending on Excel version...)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Jag Nut" <Jag wrote in message
...
I have an excel workbook that started as 148kB and is now 2.6MB, but the
size
increase is for no apparent reason, I'm not aware of doing anything other
than forwarding it by email to a colleague. When I check one of the
sheets
it shows the last cell to be at row 27364 even though there is nothing
beyond
row 26, but I can't seem to clear the range. There are no spurious
characters that I can see, what have I done?

I had this happen to me too. I've tried everything below but that didn't
help. Any other ideas?

"George Nicholson" wrote:

I can't seem to clear the range

You need to delete the extra rows (and /or columns). Simply clearing them
doesn't do what you want.

Select the "extra" rows, right click and select "Delete". Save. Check the
last cell again after you reopen the book (sometimes reopening isn't
necessary depending on Excel version...)

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Jag Nut" <Jag wrote in message
...
I have an excel workbook that started as 148kB and is now 2.6MB, but the
size
increase is for no apparent reason, I'm not aware of doing anything other
than forwarding it by email to a colleague. When I check one of the
sheets
it shows the last cell to be at row 27364 even though there is nothing
beyond
row 26, but I can't seem to clear the range. There are no spurious
characters that I can see, what have I done?