Excel, OneDrive, and Trusted Locations

if you check the event viewer after trying to open the file from One Drive and get the ‘not a trusted location’ error, there will be an error that begins with Customerization URI: https://d.docs.live.net/random string/your one drive folder. Copy this verbatim into ‘add trusted location’ in your office programs and you are G2G. PITA for sure