Turn on Manual Calculation and use F9Īnother solution is to turn off the Automatic Workbook Calculation option, instead using the Function key F9. You could also create Relational Database spreadsheets that connect your tables with unique, key fields. You can accomplish this by creating multiple spreadsheets in a single workbook, with links or three-dimensional formulas. One solution, and one that I highly recommend, is to keep your spreadsheets small and tight, with fewer fields and, if necessary, fewer records. Using a lot of graphical elements can also hinder performance.
This can cause a lag time of several seconds or more between each process.
Every time you add new records, then press the Enter key-or use features such as Sort, Format cells, or Insert/Delete Columns or Rows-Excel recalculates all those formulas. The number of records (rows), fields (columns), and formulas can slow down performance considerably.
