You might see that the Dropbox Community team have been busy working on some major updates to the Community itself! So, here is some info on what’s changed, what’s staying the same and what you can expect from the Dropbox Community overall.
Forum Discussion
Dropbox excel sheet update from web
I have an excel sheet that pulls football scores from the web. The info only updates new scores if I open the excel sheet from the original computer I made sheet on. I want to be able to open my dropbox from another computer and have scores update.
The file is static when it is on dropbox. Excel only queries when it is actually open, so sitting in dropbox isn't the right solution.
Excel won't auto update on its own, so you would almost need to write a web scraping script that updates the file locally on a schedule, then dropbox would sync the local file to the web, and then you can view it anywhere.
- Jane
Dropbox Staff
Maybe excel is not right to solve my problem. I have a football pool where 8 players have 4 teams each. We use an excel sheet and have to manuaaly input the number of wins for each team after the Sunday (and Monday night) games. I just want to have the computer do it automatically. I assumed I could put an excel sheet into my dropbox, have excel querry by using Data, From Web. But the querry only runs when I open excel sheet from the computer I originally put the excel sheet into dropbox from. If I open dropbox excel sheet from another computer, the querry doesn't run.
Isn't Dropbox just a cloud location on the web? Shouldn't it always update with the scores as the website is updated?
- atccodex
Super User alumni
The file is static when it is on dropbox. Excel only queries when it is actually open, so sitting in dropbox isn't the right solution.
Excel won't auto update on its own, so you would almost need to write a web scraping script that updates the file locally on a schedule, then dropbox would sync the local file to the web, and then you can view it anywhere.
