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.
0 kommentar(er)
