ExcelNoob222
Board Regular
- Joined
- Jun 17, 2020
- Messages
- 77
- Office Version
- 365
- Platform
- Windows
Hi all,
I have a workbook with an external data connection. I'd like the create a macro that automatically refreshes the data. However, when I run the macro I get a popup from windows security asking me to log in. My log in details are already saved so I just have to click Okay and then the data refreshes. Is there a way to automate this part so that it does not stop the macro?
I have a workbook with an external data connection. I'd like the create a macro that automatically refreshes the data. However, when I run the macro I get a popup from windows security asking me to log in. My log in details are already saved so I just have to click Okay and then the data refreshes. Is there a way to automate this part so that it does not stop the macro?
