Delete, edit, and organize
Solve issues with deleting, editing, and organizing files and folders in your Dropbox account with support from the Dropbox Community.
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
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so please give it a Like below.
Did this post fix your issue/answer your question? If so please press the 'Accept as Best Answer' button to help others find it.
Still stuck? Ask me a question! (Questions asked in the community will likely receive an answer within 4 hours!)
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?
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
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so please give it a Like below.
Did this post fix your issue/answer your question? If so please press the 'Accept as Best Answer' button to help others find it.
Still stuck? Ask me a question! (Questions asked in the community will likely receive an answer within 4 hours!)
This sounds like the way to go. thank you
Amazing @JA50! If you get this squared away (or you have further questions along the way of course), please do let us know on this discussion & itāll be a pleasure to check back with you. Happy syncing & I hope you have a wonderful Friday ahead!
Jane
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so please give it a Like below.
Did this post fix your issue/answer your question? If so please press the 'Accept as Best Answer' button to help others find it.
Still stuck? Ask me a question! (Questions asked in the community will likely receive an answer within 4 hours!)
Hi there!
If you need more help you can view your support options (expected response time for a ticket is 24 hours), or contact us on X or Facebook.
For more info on available support options for your Dropbox plan, see this article.
If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!