Overriding Login For Microsoft Query Imported Data in Excel

I am building a report for my team and using Microsoft Query to import data from Access to Excel.

When I refresh the queries, it works fine but when one of the team members tries, it asks for a username and password. I went into Excel Authentication Services and selected "None" but the other memebers still get the pop-up box as seen in the attached image.

How can I override this so that the team can also open th workbook and have the data refreshed without having to input a username and password?

Thanks.