2K PGA Tour Simulation System [Solo Society Replacement]

[mike081989]

I may have forgotten to hit save before I posted the instructions, reattaching here.

[mikemarc1]

Hey,

when i attempt your step 1 in the instructions and hit check status both change to OK and not "Source is open"

[mikemarc1]

Another quick thing i noticed...the precut leaderboard only has 155 slots for players. when i paste 156 players the bottom player has no formulas in his row...is there an easy way to add?

[mikemarc1]

The round by round tab looks good but the hole by hole sheet when i generate scores remains blank.

I'm also getting a leaderboard filled with #REF when i update the rounds in it.

[mike081989]

Quote: Originally Posted by mikemarc1

Hey, when i attempt your step 1 in the instructions and hit check status both change to OK and not "Source is open"

It will say "source is open" if you have all the workbooks open at the same time. Make sure you are linking them to the location on your computer - then hit check status with all of them open. I think OK should be fine too but if you have all open, it should really say source is open so it knows its looking at the correct workbook.

Quote: Originally Posted by mikemarc1

Another quick thing i noticed...the precut leaderboard only has 155 slots for players. when i paste 156 players the bottom player has no formulas in his row...is there an easy way to add?

For this, just go to the last player, click on the row number over on the left so it selects the whole row, and hit copy. Then click the empty row so it selects the entire row and click paste.

Quote: Originally Posted by mikemarc1

The round by round tab looks good but the hole by hole sheet when i generate scores remains blank. I'm also getting a leaderboard filled with #REF when i update the rounds in it.

That should not be happening if you have the files linked correctly. (The #REF errors). Try re-linking and see if that works. That error is usually caused when you add/delete rows or columns. Is there a specific part of the formula in the formula bar where it says #REF? If you could share a screenshot or something that would help me diagnose the problem.

The hole by hole tab isn't actually blank - the text is white. Highlight it and make it black. It will only fill in numbers for the players that are playing in that particular tournament.

Hopefully that helps. Let me know if you're still having any issues.

[mike081989]

One last thing to check would be that the scores actually populated on the round by round tab. Are numbers showing up when you run the macro? If you don't have macros enabled it won't work either.

[mikemarc1]

Quote: Originally Posted by mike081989

One last thing to check would be that the scores actually populated on the round by round tab. Are numbers showing up when you run the macro? If you don't have macros enabled it won't work either.

This is what i see in the hole by hole tab when i highlight the sheet.

Everything else has been working this time around!

[mikemarc1]

Quote: Originally Posted by mikemarc1

This is what i see in the hole by hole tab when i highlight the sheet. Everything else has been working this time around!

Ok so i figured it out..you literally have to make it black..i thought just highlighting it would work. Now i have a question though. McIlroy was -3 after the first round in the round by round tab..but on the hole by hole its showing that he's -6 after round 1.