ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   reducing file size (https://www.excelbanter.com/excel-discussion-misc-queries/76096-reducing-file-size.html)

FBr

reducing file size
 
I have been reading the threads about reducing file size by deleting unused
cells. I tried this as I have a file that has only a tiny amount of data in
it, but was almost 2Mb in size. If I saved it as a CSV file it was only 1kb.
If I copied all the data into another file it was only 14 kb. I though it was
stupid to have to do this to reduce file size so I followed the technique
suggested in other threads to delete reducing file size by deleting unused
cells and now the unused cells are now gone. When I <ctrl end I now only get
to row two instead of row 65000 and something. However it took my computer
about 45 mins to delete the empty cells & now the file has grown just under
45Mb!
(I have Outlook 2003 (11.5612.5606)


All times are GMT +1. The time now is 02:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com