Madden 18 CFM Scouting Tool

[tdawg3782]

Quote: Originally Posted by Old Man Nathy

Odd. I'll check.

Quote: Originally Posted by extremeskins04

Tdawg once I closed Excel 2016 and re-opened it I didn't have the problem anymore and I've added 6 players, but we'll see if OMN finds anything quirky.

Here is a quick video I made so you can see what's happening. Seemed like that would be easier then trying to explain it.

[extremeskins04]

Quote: Originally Posted by tdawg3782

Here is a quick video I made so you can see what's happening. Seemed like that would be easier then trying to explain it.

Yep Tdawg I had that issue the first time I opened the tool in Excel 2016, but I have not had that problem since I first closed and re-opened it.

I did the exact same thing you did and followed your step in your video and I didn't get the #VALUE! error. It kept the rating and rank. I'm not sure man.

[tdawg3782]

Quote: Originally Posted by extremeskins04

Yep Tdawg I had that issue the first time I opened the tool in Excel 2016, but I have not had that problem since I first closed and re-opened it. I did the exact same thing you did and followed your step in your video and I didn't get the #VALUE! error. It kept the rating and rank. I'm not sure man.

Really weird right? I know my fair share about Excel too and I'm stumped. Hopefully OMN can figure it out.

[Old Man Nathy]

Quote: Originally Posted by tdawg3782

Really weird right? I know my fair share about Excel too and I'm stumped. Hopefully OMN can figure it out.

This is bizarre. I downloaded a fresh copy of the tool and followed the exact steps in your video but couldn't replicate the issue. Can you upload a copy of the spreadsheet where it's happened?

[tdawg3782]

OMN when I switch archetype the Pos concat column gives a #NAME?. I feel like this is the cause.

[Old Man Nathy]

Quote: Originally Posted by tdawg3782

OMN when I switch archetype the Pos concat column gives a #NAME?. I feel like this is the cause.

Yeah that'll be what causes it, that new column gets used for all sorts of stuff. No idea why it would throw an error though. If you change the Concat function to the legacy concatenate function does it help?

[tdawg3782]

Figured it out guys. So I have a standalone version of Excel 2016. Apparently you must have a subscription to Office 365 for the Concat formula to work. That is my issue. It's not supported. Trying to find a workaround. Thanks for looking into it.

[extremeskins04]

Sorry what is the Pos Concat column? I don't see that.