Could I get one also, please.

[email protected]

I got the one you sent out on the 15th is that the updated one? If not I would like the new copy

I would appreciate a copy.

Thanks

Please!

This post could not be converted. To view the original post's thread, click here.

maverick: That happens IF the team you are changing to has the exact same game name (so, playing the same team at the same location) early in the new team's season as the team you are changing FROM has later in their season.

If you click the "Stop" button, instead of the debug button (at least in excel 2003) it should go on to the next game and in the end it should work.

Does this spreadsheet work with Excel 2007?

Quote: Originally posted by dravz on 12/26/2008Does this spreadsheet work with Excel 2007?

he has another version that works with excel 2007 ... and the 2003 one can be converted as well.

Yea I kind of thought that was the problem however when I hit end it acts like it is going to work and update everything. It finishes doing copies etc and then when I go look at the opponents rosters none of the data is present. If I go and look at the worksheets towards the end of the workbook ie OppRoster(2), OppRoster(3) etc I see the following message in there......

Error
An error occurred on the page: playerratings.aspx?tid=. Please contact customer support with more details or wait a few seconds and try again.

I know I have went thru these workbooks of Maddies before and remember seeing him set TID somewhere in there. I do not know this stuff well enough though to fix this problem on my own. I know just about enough to be dangerous.....haha.

Thanks in advance for any help you can offer

It seems that there is an error when running the query to refresh the data on those worksheets. When I examine the query it looks like it is having trouble establishing the TID....the screen I get when editing the query states the following.....

An error occurred on the page: playerratings.aspx?tid=["tid"]

Todd... can you send me a new copy of the workbook.

[email protected]

Thanks.

Hey guys - I've got the version Todd sent on 12/10 (thanks Todd!) but recently when I update after a game, I can't see any players or ratings on the opponents sheets. I figure I need to click something somewhere or refresh or something really simple, but I'm not sure what I'm missing. Anyone know? (I tried hitting the Verify GD sign-in button on the TeamInfo&DataRefresh sheet). Thanks for any feedback.

I just finished sending the above requested copies. Once the holidays are over I will take a look at the workbook and work to correct some of the errors.

Thanks Todd - You're awesome! Hope you and everyone else who reads this have a great holiday weekend!

Can i please get a copy of the updated version [email protected]