PDA

View Full Version : Suggestion if the spreadsheet is running slowly



admin
7th August 2015, 04:53 PM
If you find the spreadsheet is running slowly, which is not uncommon for v2.16 Advanced, one option is to change the Excel settings to run background calculations manually rather than automatically.

To change this setting select File -> Options. In the formulas tab select Manual for 'Workbook Calculation'. I recommend ticking the box next to 'Recalculate workbook before saving'.

Every time you press F9 or save the file (Ctrl+S) the spreadsheet will update the background calculations. If you just want to update the calculations on the active sheet press Shift+F9.

This manual approach should speed up data entry in the Bets worksheet.