I have an excel file with 3 sheets. each sheet has a table linked to sql views. each time i open the file for the first time i get prompted for the password when i refresh the tables (or list objects).

i want to be able to open the file from access and refresh the tables without the password prompt popping up.

can i set the connection up to retain password info??