Minimize Excel File Size to 5kb For Free

one of the significant drawbacks when using Excel in certain situations is that files can become too big and hard to work with here are a few reasons why this could happen to you as well as remedies for such situations a key assumption we must make is that the issues we'll discuss in this lesson are not due to a slow PC because that is a completely different problem okay very well reason number one the data you are working with is too big let's say that if your data source is above 100,000 rows and contains many columns you can potentially have a situation in which Excel would take a significant amount of time to calculate and process the functions you've created in the spreadsheet all of this depends on what type of operations have been used in the file in particular Excel has a hard time when it needs to process complicated nested functions like the ones you see here in such a scenario one quick fix would be to carry out some of the operations with pivot tables which are much lighter computation wise this is one fix another is to think of a way to carry out the same operation but in a lighter way for example vlookup is much lighter than index and match although index and match is superior in most cases if we want to improve efficiency vlookup would be preferable a third suggestion is to be careful with if error and is error functions that are added in front of your main function in a given cell see yes this can be very convenient but it also makes files quite large so whenever working with large data this is certainly one potential source of efficiency so that's the first and by far the most common reason for problems with Excel file size here's another one it could happen although rarely that your file size increases after importing external sheets copying external formatting or carrying out another operation that has to do with the outside world if this happens please try the following locate the last cell in your sheet containing any content okay then you should select the row directly beneath that cell hold shift and press the down arrow to select all rows within the file that are under the last cell with content then go ahead and delete these rows with control and - they should be empty anyway sometimes I'm not really sure why but we can have information that is stored here although not visible and this makes file sizes larger to be sure that the issue has been taken care of please do the same operation with empty columns to the right - another reason why your file could be too big is that some images have been added and they are quite large in such situations you can either compress the images and add them back to the file or simply remove the images if they are not necessary okay we're doing great one thing I have noticed is that many users are reluctant to tidy up their files and let go of unused sheets calculations or charts in the process of building a model frequently we have sheets that are kept as old please consider transferring...