|Image Credit: FreeDigitalPhotos.net|
If the crawl is intolerable, turn off the automatic calculations. This will ease up your workbook that has complex calculations, with huge databases that requires excel to keep on refreshing performing all the calculations live. You can change the setting into manual through the Options dialog. If you want to update the sheets, and perform the calculations, you can always press F9 like what you do in refreshing web pages in browsers.
Formatting is, more often than not, the reason your workbooks in snail pace. Save the workbook as new file so that it will purge the formats and it won’t bloat. Like how it used to be with The Elder Scrolls IV: Oblivion, if you played it back in 2006. Aside from that, you can always clear formats on selected cells. Make use of that ribbon interface, it was put up there for a reason.
•Use Search Commands—
Yes, the ribbon interface promised to put functions of every MS Office suit at the face of the users for easier, for the lack of a better word, use of the functions. However, some of the vital functions are buried inside the menu. You can always install the add-on, Search Commands, so ribbon won’t be a problem since you just have to search commands and functions at will.
•Delete Name Ranges, Excess Formatting, Unnecessary Areas—
Simply put, just follow the instructions carefully. That is basically, it.
It is pretty tempting to use the Array formulas to automate everything, but
sometimes, this is the problem: automation for the reason that it keeps Excel from performing calculations synchronically. Use Array formulas if it is really needed. Rule of thumb: if the array formulas are IF statements, get rid of it.
If the data you are going to include in invoices, audits, sheets, etc. etc. are no longer going to be updated, just paste the values. Get rid of the formulas so that it won’t slow down things.
•Images— Yes, sometimes, the images we put on the rows and columns are actually the ones slowing down everything because of its huge unnecessary footprint.
Last, but not least – utilize a course in Excel to become a more avid user of the program. A faster program and a faster user will create results in no time!