View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default Excel file size dramatic increase

Well..., it might happen when the "last used cell" is a far away cell.
I would suggest to press Ctrl+End in order to check the location of that cell.
You may also delete all "empty" rows/columns under the used region.
Micky


"Hager" wrote:

Hi

I have an problem with an excel file. The file was quite large about
20000KB. About a month ago the file jumped to just over 56000KB in size
(although I had added some data it was only a few lines). Although it works
it is very slow and prone to sudden crashes.

I have copied the file and removed all but one sheet (effectively stripped
out the data - bit by bit) and it is still over 56000KB.

Is the file corrupt? And if so is there a diagnostic/repair facility?

thanks for any help