Dear all, As the picture, I need to use vba code to refresh the data. Here is my follow, first, i will click the "Refresh All" button, after I input my "User" and "Password", the data will refreshed. Thank u