Closed Thread
Results 1 to 2 of 2

How to permanently enable Data Connection?

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    Newport Beach, California
    MS-Off Ver
    Excel 2007
    Posts
    6

    How to permanently enable Data Connection?

    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?

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,570

    Re: How to permanently enable Data Connection?

    Welcome to the Forum, unfortunately:

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.
    Ben Van Johnson

Closed Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1