Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to set sheet size to reduce file size | Excel Discussion (Misc queries) | |||
reduce the size of a file | Excel Discussion (Misc queries) | |||
reduce file size | Excel Discussion (Misc queries) | |||
Need to Reduce the file size | Excel Discussion (Misc queries) | |||
Reduce size file | Excel Discussion (Misc queries) |