PDA

View Full Version : Drop Down Menu Error



danksies
8th March 2020, 02:01 PM
Thanks for spreadsheet ASB. Recently encountered a problem where I opened up the sheet and a notification says "We found a problem with some content in 'Betting Tracker Spreadsheet'. Do you want us to try and recover as much as we can? If you trust the source of this workbook, click 'Yes'". After excel tries to recover the file another popup says "Excel was able to open the file by repairing or removing the unreadable content. Removed Feature: Data validation from /xl/worksheets/sheet1.xml part" and then the drop down menus are no longer available. Any thoughts?

admin
9th March 2020, 03:50 PM
Hi danksies,

One option is to paste your data into a fresh copy of the spreadsheet and see if that fixes the issue.

If you want to stick with that sheet then you would have to manually enter all fields rather than select from drop down menus. It's not the end of the world but it would increase the chance of data entry mistakes due to misspellings.

Let me know if you have further questions.

stomarti
17th March 2020, 01:17 AM
Hi danksies,

One option is to paste your data into a fresh copy of the spreadsheet and see if that fixes the issue.

If you want to stick with that sheet then you would have to manually enter all fields rather than select from drop down menus. It's not the end of the world but it would increase the chance of data entry mistakes due to misspellings.

Let me know if you have further questions.

Hi mate, I want to ask that sheet will be updated in terms of year ?? There is only 2019 and 2020, I think it is better that we can change it. If it's possible I appretiate for that

admin
17th March 2020, 10:26 AM
Hi stomarti, the years that show up in the drop down menus for the spreadsheet are based on the dates that you enter in the bets worksheet. It automatically updates as new dates are added. Once you enter your first bet that was placed in 2021, then 2021 will be available in the list.