This has a direct correlation with the Excel file size. If you have an Excel workbook that has some worksheets that are not needed (and are not being used in any formulas), see if you can get rid of those. The best solutions are often the easiest ones.Īnd this technique is more of common sense and less of any Excel wizardry. The results you get would vary depending upon your data and files.īased on your workbook, you can use one or more of these tips.
Excel treats the last most cell on which data entry is done as the end of the sheet. One of the most ignored action in Excel files especially in 2007 or later versions that at the end of Column or Row we write something accidently and then we simply delete it. If your file contains simple data and still its size is huge try to copy all the data into another file and then save the file as another name.ħ. BEWARE Excel files might contain some viruses disable macros before opening (Macro - Macro Security - and select High security) until you are very sure that the macro contained in the excel file are safe don't enable it.Ħ. If you have shared that workbook for multiple users then remove the sharing.ĥ. Use paste special to convert formulas into Values so that it can be converted in values and reduce the size of file and also the loading time will be reduced but still recommended not to convert all the formulas as values, but recommended to convert all external links in to values so that your values will remain intact to the person you are emailing this file or if external link is not found.Ĥ. Home - Conditional Formatting - Clear Rules - Clear Rules from Entire Sheetģ. Remove the conditional formatting if it is not required. If you are using conditional formatting it also takes more time during opening an excel file. This also increases the size of worksheet. Sometimes we select the entire row or column or sheet and select Fill color or Borders. Don't format your worksheet more than needed. Uncheck "Apply to selected picture only".īecause images takes most of the space in any file reducing that can help to reduce excel file size up to 75%Ģ. Right click on the image and click compress or from the formatting tab click on Compress Picture (can be found in top left corner). Here are some tips to keep or reduce file size using Excel 2007.ġ. Smaller size of any excel file is very important for portability and fast access. It seems frustrating but we can take precautions to avoid such delay by keeping the Excel file size optimized. More often you may have noticed delay while Loading a simple file or during normal Calculation. But sometimes contents file can enlarge size of file.
Structure of an Excel file is designed that consumes low memory space on drives.
0 kommentar(er)
