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.

Betfair
Results 1 to 6 of 6
  1. #1
    New Member
    Join Date
    Aug 2015
    Posts
    3

    losing the years

    hi guys love the spreadsheet, I'm using on a mac and having a problem with the years disappearing in the performance summary. how do i add more years like next year and so on as mine has lost 2015 and only shows up with 2012 can't work it out, it had 3 months of bets recorded and didn't want to start again
    thanks

  2. #2
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi spantec,

    I'm afraid I don't have a mac to test the spreadsheet on, but my recommendation is to first unlock the Performance Summary sheet (password is sport). Then scroll to the right of the Performance Summary sheet to the point where you see a break in the column letters, e.g. AS, AT, AU, BC. Note that BC doesn't immediately follow AU, indicating hidden cells. Highlight the two column letters and then right click and select Unhide. This will enable you to view the working cells that are used to populate the year dropdowns. Depending on the spreadsheet version the years will be displayed in the column "All Years". You could manually override these cells to input the current year along with 2016, 2017, etc., to future proof the sheet.

    Let me know if you continue to experience issues.

  3. #3
    New Member
    Join Date
    Aug 2015
    Posts
    3
    awesome managed to change the years with your instructions thanks admin

  4. #4
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    I've played around with the spreadsheet and it may be that the year dropdown menus were working for you. It could be that the dropdown menu had scrolled down to a point where the years weren't visible.

    If anyone is experiencing a similar issue, before editing the spreadsheet, try the following:

    Click on the dropdown menu.

    2015-09-03_spreadsheet_date_2.gif

    Scroll up using the arrows to see if you are in fact looking at the top of the available fields.

    2015-09-03_spreadsheet_date_3.gif

    Select a year if one is available.

    2015-09-03_spreadsheet_date_4.gif

    Note that you must have at least some data in the Bets worksheet for the performance summary filters to work.

  5. #5
    New Member
    Join Date
    Feb 2016
    Posts
    1
    this is where im having an issue my drop down menu is only showing 2009 we are 2016 i added a bet still showing up blank

  6. #6
    Moderator
    Join Date
    Aug 2011
    Posts
    989
    Hi jayoneill, have you tried the sheet unlocking recommendations mentioned above?

 

 

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
  •