Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
Solved
How to autosave an excel file to Dropbox every 10 min
I just spent two hours on an excel file only to have excel crash before i saved it and lost my work. I am using MS Excel 97-2004 on a MacBook Pro and right now have to manually save all work. How ...
Hello slstewart249
There isn't a way for Dropbox to do this but as I understand it there is an auto-save feature in Microsoft Excel. I believe most versions have this. Take a look at this article https://support.office.com/en-us/article/use-autosave-and-autorecover-to-help-protect-your-files-in-case-of-a-crash-551c29b1-6a4b-4415-a3ff-a80415b92f99
or https://www.justanswer.com/computer/1ay5s-turn-off-autosave-feature-excel.html
Hopes this helps
It appears I somehow integrated Dropbox and Excel. A floating Dropbox logo appears on the right side of my workbook. Apparently this is to allow multiple people to work on the spreadsheet (trying to keep up with the functionality available in Google Sheets for years?)
That said, I haven’t found a way to disable it yet.
That said, I haven’t found a way to disable it yet.
Rich
Super User II
Super User IIThe floating Dropbox logo is the Dropbox Badge. It doesn't allow simultaneous editing, but does alert you when others are in the document and it allows you to load the latest changes if any, among other things. Simultaneous editing is possible and has been for a long time through the Dropbox website (the same way Google Docs does it).
This feature wouldn't have anything to do with the Dropbox integration in Office, if you have that. That would have been accomplished by adding Dropbox as a Place within Office.
Have you tried to select a folder outside of Dropbox yet, just as a test to see if Auto-save will work at all?
- Ok, I removed Dropbox as a Place from the options in Office. Then I closed all Office programs.
When I opened Excel again, the Dropbox badge was still there, so I changed the selection right below Dropbox as a Place (I took a screenshot, but it won't paste here...possibly because I used "Quick Reply".)
I also selected a folder outside of Dropbox for both the Default File Location and Default AutoSave location.
AutoSave is still greyed out. And for extra measure, here's a screenshot showing the greyed out AutoSave option:
- Chris_J
Super User alumni
Have you tried re-installing Microsoft Ecel?
- not yet. Will I lose all my settings?
- Rich
Ok, we seem to be confusing two separate features. AutoSave (as shown in your screenshot), and the feature that automatically saves files every 10 minutes for file recovery.
The feature you're referring to does not work with local folders. It can only be enabled and used with OneDrive, OneDrive for Business or Sharepoint Online.
- Ohhhhh. Thanks. I guess that solves the mystery. I thought the feature that automatically saves files every 10 minutes was turned off. I've lost too much data in the past to leave that off :)Thanks for the help and sorry for the confusion.
