If your data source requires a password to connect to it, you can require that users enter the password before they can refresh the external data range.
In Outlook's Home tab, users will see the ND Save button.
–––––––––––––––––––––––––––––––––––––––––––––––––––––––––––– Our new navigation method allows easier access to data.
Because of the simply method of navigation, you will save more time, and are able to complete work in less time to ensure customer satisfaction.
Store the passwords that you write down in a secure place away from the information that they help protect.
Note: Excel prompts you for the password only the first time that the external data range is refreshed in each Excel session.
The next time that you start Excel, you will be prompted for the password again if you open the workbook that contains the query and then attempt a refresh operation.