![]() Check on your Excel formulasĬalculating formulas is the most time-consuming part of any large Excel workbook, so it’s important for you to seriously look at what kind of formulas are being used. If you’re bringing in lots of data from another location, then consider moving all of your data and calculations in the one workbook. It takes more processing and computational power if there are formulas or other links to other files, because Excel has to jump out of the current file and get information from somewhere else. Remove any links to other Excel filesĭoes your file have any links to other Excel workbooks? ![]() Want other tips to reduce the file size of your Microsoft Excel workbook? Try the Ultimate Guide to Reducing File Size in Excel. If this cell is far beyond where your data is, then you’ll need to delete some rows & columns. To check on the Used Range, press Ctrl + End and the cursor will jump to the end of the workbook. This range of cells is called the “Used Range” and it’s what Excel keeps in its memory. When this happens, Excel still “stores” those cells in its memory and if there are a lot of unused cells, it can slow down your Excel workbook. ![]() In old Excel files, some additional rows & columns might have been used a long time ago but the data has now been deleted. Get rid of unused cells by reducing the Used Range ![]()
0 Comments
Leave a Reply. |