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
Thanks Rich. Your solution seemed perfect... unfortunately, it didn't change anything. The AutoSave switch is still greyed out.
Rich
Super User II
Super User IIThen I'd suggest that there's something else preventing it. The Dropbox folder is just a folder like any other. Can you select a folder elsewhere on your computer?
- 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.- Rich
The 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.
