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 3 of 3
  1. #1

    Performance Summary Filter not working

    Hello, first just wanted to say thank you very much for this fantastic sheet, I've been using it for some time and have recommended it to my friends!

    Had a bit of a break from betting and just come back to it, so figured I'd have a clean slate and use the newest version of the sheet too (I'm on v2.21 of the basic one now)

    One thing I've noticed is the layout of performance summary is now changed, which I think looks better and cleaner

    However, changing the "Main Filter**" (B24) on performance summary doesn't appear to change the parameters of the betting performance table (starting at B38). However, I've noticed that if I change the filter, save, exit and reopen then the table WILL have updated.

    I'm a bit of a numberphile and love looking at all the data and whilst not a complete headache it can be a bit annoying! I've done some basic googling and have ensured that both my excel and individual workbook settings are set to automatic calculation, but beyond that is beyond my area of expertise :P

    Just wanted to say thanks again for the sheet and was wondering if anyone else had similar issues, cheers

  2. #2
    Join Date
    Aug 2011
    Hi Kildorragh,

    Thank you, I'm glad you like the spreadsheet!

    You're the first person to report this particular issue. What version of Excel are you using? Are you using Windows?

    Try the following shortcuts to see if any of them force an update:

    1. F9 (Calculate all sheets in all open workbooks)

    2. SHIFT + F9 (Calculate the active sheet)

    3. CTRL + ALT + F9 (Recalculates all cells on all worksheets in all open workbooks)

    4. CTRL + ALT + SHIFT + F9 (For Excel 2002 will rebuild all dependency trees)

  3. #3

    I'm so sorry to waste your time, I've spent ages trying to fix it and am embarrassed to admit a restart never occured to me which has fixed my problem

    Thanks again for the great sheet and good luck for all your punts in the future!




Posting Permissions

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