CODEWITHSUNDEEP
excelvbamicrosoft-query
Logan
Logan

Reputation: 3

Automatically Refresh Excel Data Connections

I have a data file that has two Microsoft Query Connection Queries that pull data from an outside source. My goal is for these connections to update automatically within my local Microsoft Excel application. I have uploaded this Excel file on to the online version of Microsoft Excel, thus when it updates automatically in my local Microsoft Excel version, it will update the online version.

This refresh needs to be done independent of use of the system, meaning that no person will need to open the file or refresh the file, the local Excel version needs to not be opened by a person, but could be by some sort of code.

I have tried using the automatic refresh after [x] minutes, but that will only update when I open my local version AND that amount of time has passed. I do not want to have to open the local data source, because the eventual goal is to have a separate system that will update this in the background, that I do not manage at all.

If you have any advice on how to make this work, that would be great!

Upvotes: 0

Views: 1301

Answers (0)

Related Questions