I have live stock prices on my excel worksheet, I want the stock price to be automatically update itself everytime i open the worksheet. I already checked the box that said "Refresh data when opening the file" in the External Data Range Properties, however everytime i close the worksheet and reopen it, it gives me the "security warning" - Data Connection have been disabled. I tried to change the option on the security warning to :"Enable this content", but it still asks me the same thing everytime i open the file. How do i permanently enable the data connection so that i don't have to go through the security alert everytime?