Re: The JT Roster Builder Utility (beta) - Download Link Included
The value is disappearing in the field because Excel is not recognizing it as a valid named range. We have to figure out why.
Do only the following with the attached file:
Open and click on the 'Formulas' tab at the top and then click 'Name Manager'. The columns we're interested in are 'Name' and 'Refers To'. These are named ranges and tables referenced in the workbook. Click on the filter button on the top right and make sure the filter is cleared.
First look for the following ranges and references. The references ('Refers To' column) are in parenthesis:
AllPlayers_rnge (=AllPlayers[All])
AllPit_rnge (=AllPit[Pit])
AllPos_rnge (=AllPos[Pos])
Allrook_rnge (=AllRook[Rookies])
TeamAll_rnge (=TeamAll[Team])
TeamPit_rnge (=TeamPit[Team Pit])
TeamPos_rnge (=TeamPos[Team Pos])
TeamRook_rnge (=TeamRook[Team Rook])
The above ranges should have a small tag icon next to them. In addition, you should see the tables (what I have in parenthesis) listed as well with a small grid icon next to them.
If all is good, do the following:
1) Click on the drop-down to see if you have the full list of players.
2) Right-click the drop-down (design mode), and check ListFillRange. It should say 'TeamAll_rnge'
3) If everything is okay, then click the search filter once and do steps 1-2 again. Repeat this step until you've cycled through all the search filters. The ListFillRange field should change every time you click the filter.
4) If all is good then select a different team, click 'load team' and repeat steps 1-3.
If at any point the drop down messes up again, go into the Name Manager as you did previously and check if the ranges and tables are there with the appropriate references.
Report your results to me, including specifically where things went wrong and we'll go from there.
Btw, I forgot to ask: you previously mentioned that you were using an old computer and switched to a new one. Did your old computer have Excel 2013 or were you using a previous version?
The value is disappearing in the field because Excel is not recognizing it as a valid named range. We have to figure out why.
Do only the following with the attached file:
Open and click on the 'Formulas' tab at the top and then click 'Name Manager'. The columns we're interested in are 'Name' and 'Refers To'. These are named ranges and tables referenced in the workbook. Click on the filter button on the top right and make sure the filter is cleared.
First look for the following ranges and references. The references ('Refers To' column) are in parenthesis:
AllPlayers_rnge (=AllPlayers[All])
AllPit_rnge (=AllPit[Pit])
AllPos_rnge (=AllPos[Pos])
Allrook_rnge (=AllRook[Rookies])
TeamAll_rnge (=TeamAll[Team])
TeamPit_rnge (=TeamPit[Team Pit])
TeamPos_rnge (=TeamPos[Team Pos])
TeamRook_rnge (=TeamRook[Team Rook])
The above ranges should have a small tag icon next to them. In addition, you should see the tables (what I have in parenthesis) listed as well with a small grid icon next to them.
If all is good, do the following:
1) Click on the drop-down to see if you have the full list of players.
2) Right-click the drop-down (design mode), and check ListFillRange. It should say 'TeamAll_rnge'
3) If everything is okay, then click the search filter once and do steps 1-2 again. Repeat this step until you've cycled through all the search filters. The ListFillRange field should change every time you click the filter.
4) If all is good then select a different team, click 'load team' and repeat steps 1-3.
If at any point the drop down messes up again, go into the Name Manager as you did previously and check if the ranges and tables are there with the appropriate references.
Report your results to me, including specifically where things went wrong and we'll go from there.
Btw, I forgot to ask: you previously mentioned that you were using an old computer and switched to a new one. Did your old computer have Excel 2013 or were you using a previous version?
Comment