Need to see if your shared folder is taking up space on your dropbox đŸ‘šâ€đŸ’»? Find out how to check here.

Forum Discussion

JA50's avatar
JA50
Explorer | Level 3
8 years ago
Solved

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 drop...
Delete
restore
sync
Web
  • atccodex's avatar
    atccodex
    8 years ago

    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.

JA50's avatar
JA50
Explorer | Level 3
8 years ago

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?

Jane's avatar
Jane
Icon for Dropbox Staff rankDropbox Staff
8 years ago
Hey JA50, I appreciate it that you circled back to us with the detailed description of how you’d like to setup excel & Dropbox. atccodex has included some great advice above (& thanks a lot for that, it was very helpful! :slight_smile: ), though let me elaborate on my previous reply a bit for you below!
 
Now JA50, I’m not sure how you could go about updating your excel sheet from your online source as it’s not my area of expertise, though you may have a look at Microsoft’s resources regarding that & take it from there. 
 
When it comes to Dropbox though, I’d recommend having a look at your account online to see if your latest edits are updated on your excel file as expected (meaning from your device to your account online) :desktop: âžĄïž đŸ•žïž. If you can see everything as expected on our website, then this indicates that you’ve followed the right path. From there, we can shift our focus to your second computer. In case you’re still unable to view the last edits you’ve made to your spreadsheet, then this could indicate an underlying syncing issue on your second device đŸ•žïž âžĄïž:computer:. 
 
Hopefully this sheds a bit of light on your initial question, though do let us know if you have any follow-up queries. Thanks again! 

About Delete, edit, and organize

Solve issues with deleting, editing, and organizing files and folders in your Dropbox account with support from the Dropbox Community.

The Dropbox Community team is active from Monday to Friday. We try to respond to you as soon as we can, usually within 2 hours.

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X, Facebook or Instagram.

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!