Welcome guest, is this your first visit? Create Account now to join.
  • Login:

Welcome to the Australia Sports Betting Forum.

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Results 1 to 1 of 1
  1. #1
    Moderator
    Join Date
    Aug 2011
    Posts
    888

    Suggestion if the spreadsheet is running slowly

    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.
    Last edited by admin; 7th August 2015 at 04:57 PM.

 

 

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •