The JT Roster Builder Utility (beta) - Download Link Included

[JTommy67]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Be sure that every time you switch teams you click on the grey "load team" command button immediately to the left of the team select cell.

Let me know if this solves your issue.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Be sure that every time you switch teams you click on the grey "load team" command button immediately to the left of the team select cell.

Let me know if this solves your issue.

Yeah, I do that and it still doesn't work. That's the only part for some reason that isn't working. Everything else loads up fine.

[JTommy67]

Re: The JT Roster Builder Utility (beta) - Download Link Included

At this point I'd recommend zipping up your RBU.xlsm file and attaching it here so I can look at it.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

At this point I'd recommend zipping up your RBU.xlsm file and attaching it here so I can look at it.

Hope this works. Thanks for looking at it

[JTommy67]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Okay, this file was working fine for me, so we're going to have to walk through some steps.

First thing, right-click one of the tabs at the bottom and select "unhide". Then select "Lists" from the pop-up menu. Now do the following:

Select a team from the "select team" field and click "load team."

Now check the "lists" page that you just unlocked and check to see that all columns with headings are populated with names.

Let me know what you find.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Okay, this file was working fine for me, so we're going to have to walk through some steps.

First thing, right-click one of the tabs at the bottom and select "unhide". Then select "Lists" from the pop-up menu. Now do the following:

Select a team from the "select team" field and click "load team."

Now check the "lists" page that you just unlocked and check to see that all columns with headings are populated with names.

Let me know what you find.

Yeah, there all they're on the list page, but it doesn't populate on the "Main" tab? Still only shows the first player on that team and no one else.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

When I click on the player search in the "main" tab menu, the player search bar expands out several squares larger?! And then when I click another box the player search bar returns to normal? That is the only drop down bar that does that in the entire excel sheet? All the other drop down bars work fine.

[JTommy67]

Re: The JT Roster Builder Utility (beta) - Download Link Included

On the main page, click the developer tab at the very top. (If you don't see it, navigate to Excel options by clicking the Office button in the upper left-hand corner, then clicking 'Excel Options' at the bottom of the pop-up menu. Make sure 'Show Developer Tab' is checked.)

Click on 'Design Mode' at the top to highlight it. Now right click on the drop-down menu for players and select 'properties'. Look for the field called 'ListFillRange.' If it's blank, then reload the years on the Settings page and check it again.

Report to me what you see after doing this, please.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

My cursor also changes when I scroll over that drop down bar compared to the other drop down bars?.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

On the main page, click the developer tab at the very top. (If you don't see it, navigate to Excel options by clicking the Office button in the upper left-hand corner, then clicking 'Excel Options' at the bottom of the pop-up menu. Make sure 'Show Developer Tab' is checked.)

Click on 'Design Mode' at the top to highlight it. Now right click on the drop-down menu for players and select 'properties'. Look for the field called 'ListFillRange.' If it's blank, then reload the years on the Settings page and check it again.

Report to me what you see after doing this, please.

List fill range stays blank

[JTommy67]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Okay, right-click the drop down again and insert the following into ListFillRange (if it will let you):

AllPlayers_rnge

Close the window, turn off design mode and see if the drop-down works then.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Okay, right-click the drop down again and insert the following into ListFillRange (if it will let you):

AllPlayers_rnge

Close the window, turn off design mode and see if the drop-down works then.

"AllPlayers_rnge" keeps disappearing from the list fill range after I close it. Still not working

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Whenever I paste AllPlayers_rnge in the box and click to another box it automatically disappears?

[JTommy67]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Alright this is starting to look like a problem with a MS Excel update which apparently provokes this problem. Scanning the web I'm seeing a number of complaints that this happened after installing a recent update.

Since I don't have the 2013 version we're moving into more difficult territory. For now, check your version number.

The latest version appears to be 15.0.4551.1011

If you have a prior version, try updating Excel. If you have the latest, let me know. There are some other things to try.

[td7]

Re: The JT Roster Builder Utility (beta) - Download Link Included

Downloading that version now. Hopefully it will work. Thank you so much for taking the time to help me with this, its greatly appreciated!