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.