• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Connecting Excel file to the secured location.

Jagdev Singh

Active Member
Hi Experts

I want to link/connect my Excel file to the file available at a secured side. I have Data Source and location information with me. Could you please guide me how can I set the connection, so that everytime I just need to refresh my XL sheet and it will pull updated data from the secure XL file.

Regards,
JD
 
Excel doesn't know about networks etc that is an Operating system issue
This sounds more like a networking or VPN style problem than an excel problem
 
Hi Hui

There is no issue in XL. I created a connection last year while doing R&D, but now forgot the path I used. Data - Get External data - From Data Connection Wizard.

A window got popped up and asked me Data Source and location, then it pulls the data from the location where the XL file is saved to this XL file. I won't have to go to the site to get the refreshed data. I just have to go the respective sheet of my XL file and right click at the top and press the refresh button. The updated information from the sourced file gets updated in my XL file.

Regards,
JD
 
Back
Top