I am using a sheet that has a query in it that goes out to an internal (to our company) website. It goes out to the web to pull in 3 datasets. In excel2010, it would ask me for my password credentials one time and go grab the 3 datasets. I upgraded to excel 1016 (via office365). Now, when I execute the query, it prompts me for my password 2x for each dataset. So I need to enter my credentials 6 times(!) as opposed to once with excel 2010. I have made sure the 'remember my credentials' box is checked as well.

I have gone back to my excel 2010 version and ran it again and confirmed that it only asks me once for my password. I have confirmed that the "Trust Center Settings" are the same between the two versions.

Any idea what is happening?