I have two different files, with no noticeable differences between them (they are basically two different versions of the same file, yet one of them is 675kb, and the other one is nearly 7Mb???
Tried a couple of things but the size of the file is messing with the speed of my operations.
Anybody experienced this before?
Good morning JC_VILLA789
** Only try this on a copy of your file - don't use original **
You may find that your large file has blank rows in it - rows that don't contain actual information, but are recorded by Excel as being used. The same thing goes for columns. I suggest you try using this macro by Chip Pearson which will eliminate such rows - run it on each worksheet in the workbook. Then save your file and close it, then check the size.
http://www.cpearson.com/excel/deleti...eleteBlankRows
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks