Office 2016 Home and Business is installed on each PC.
The key to understanding what makes excel slow lies in understanding how excel calculates and recalculates when it first opened and then when subsequent changes are made to the worksheet.
At a very basic level if any cell is dependent on another cell for determining its value, the independent cell will be calculated first followed by the dependent cell.
For example, if I have a cell in which I count the average of the numbers in other cells, the final answer (average) is automatically updated and written in the cell when I click out of it. You can, however, fix cells not updating or excel formulas not updating very easily using a lot of ways. From here, go to Calculation and then select “Automatic”. In version and above, you can just click on the big office button and then go to “Excel Options” and move over to the “Formulas”.
Then go to “Workbook Calculation” and set it to “automatic”.
The dependency list is dynamic and as and when new formulas are entered, rearrangement and sorting of the chain takes place.
The first time a workbook is opened, the process may take longer (and will be likely slow for complex workbooks) than during initial calculations simply because the first time, Excel has to start from scratch while the second time, it has some benefit of already having created the dependency tree beforehand.Now let’s get back to doing something about that slow excel workbook of ours !All else being equal, the cell towards the top and left will be calculated first before cells towards bottom right are processed.Excel 2007 and later versions sport a much bigger grid which tends to amplify poor spreadsheet design.An Excel spreadsheet that seemed a bit slow in Excel 2000 would likely get bogged down to a crawl in Excel 2007 if you, like me, are using the same hardware.So say if cell B1 refers to cell A1, either using a formula (B1 = 10*A1) or a direct reference (B1 = A1), the cell A1 will be calculated first.