View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Ng Jeremy Ng is offline
external usenet poster
 
Posts: 1
Default Reduce File size

Hi,

We have 1 file which previously have alot of sheet into it & file size is
very big, now we delete all sheets except keep 1 sheet with a simple table &
small text box, total about 105 rows.
Now the file size still very big of about 7,200KB.

When I try to select row 1 to 105 & delete all data & sheet look totally no
data, saved BUT still back to about same size.

I even try step of point at row 106, press Ctrl+Shirt+down arrow key, then
delete entire row, also go to last column Ctrl+Shirt+righ arrow key & delete
entire column. After saved still same file size.

Even I highlighted WHOLE sheet & copy to new file new sheet & saved, still
same size.

BUT if I just copy row 1 to 105 to new file then size reduce to about 800MB.

Please someone give guidance about what is happen & how can I find out what
cause it & reduce the file size.

Thanks alot,
Jeremy