I have an Excel workbook which has seven different OBDC queries on seven different tabs set to refresh on opening of the file. In data Properties, I have "Save Password" checked for each one, but for some reason, I still get asked four times to enter the password for four of the queries when I open the workbook. Is there a workaround VBA code which will enter this password for me automatically?