data connections refresh

Hello I've created date connection to my sheet which simply an existing excel file. I need to modify that file to get the updated records in my sheet. The problem that i need to close my sheet before i modify the existing excel file. Is there a way to modify the source (The data connection file)...

Hi all, Hoping someone can guide me or help me? I have an excel work book which has multiple MSSQL queries which pulls data and puts it in to tables for reports. The issue I have is I have created an update button (refreash all basicly) however I have to keep entering the password. I know I...

Hi, I have the below macro in my workbook however due to increased number of SQL queries and the fact I need to enter the password for them all it appears the macro locks the sheets before the data is refreshed. Excel pops up with a message that says the data can not be refreshed as the sheet...

Hi, I have been looking for a solution to refresh multiple data connections within my workbook but only enter the password once. I don't want to store in the workbook as its not encrypted and windows authentication is not an option. The password and username is the same for all the...