I am working with my Azure team to resolve access to ArcGIS Portal from within the ArcGIS for Excel add-on. It was working, but after they made web application firewall changes, we can no longer sign-in. When I enter the Portal URL, a red message states "The specified ArcGIS Online (or ArcGIS Enterprise) URL is not valid."
We are able to login in our Development environment. They wanted to know if this application requires "Cookie based Affinity settings?"
Our Development environment's web application firewall has this setting enabled.