#1   Report Post  
Posted to microsoft.public.excel.misc
FBr
 
Posts: n/a
Default 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)
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Reducing size of a file with no data Oglu Excel Discussion (Misc queries) 7 February 18th 09 05:26 PM
Function To Dynamically Display File Size MDW Excel Worksheet Functions 1 February 16th 06 09:45 PM
pivot table cause file size to grow Grd Excel Discussion (Misc queries) 0 November 10th 05 06:10 PM
File Increase in size Martinj Excel Discussion (Misc queries) 7 November 7th 05 02:00 PM
excel file size bloat cwee Excel Discussion (Misc queries) 1 February 11th 05 05:16 PM


All times are GMT +1. The time now is 09:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"