We're making changes to the Community, so you may have received some notifications - thanks for your patience and welcome back. Learn more here.
Forum Discussion
DB on MacOS is corrupting my files (now irreversibly)
Hi,
for a while now I have been having problems with my DB-stored files on my Macbook. I use DB on a Windows (PC) and Macbook Air. Everything's fine on Windows, but the files do not open when I try on Mac. I have MacOS 10.15 (Catalina), running on Macbook Air. DB version is 84.4.170.
The files stored outside DB work fine, so it's DB, not the computer.
The message I'm getting is something along the lines of (I'm translating from Polish): Excel could not open the file ....xlsx due to an incorrect format or file extension. Check if the file has been damaged or if the extension does not match the format.
It used to work fine when I downloaded the file directly from the website and saved it again on my DB (replacing the corrupt version there). I figured if that's what it takes, I can wait for an update and work with this for now.
But yesterday I've spent some time editing a file on my Macbook, and today when I launched my PC it turned out it never synchronised. I checked the Mac, and the file is there, it has yesterday's date, Dropbox is on, but the file is corrupt so I can't open it. It's not visible through the browser version (it has the previous date there). I tried copying the file to another folder on DB and it copied there, synchronised across the devices, but with the previous date (!). Without any of my yesterday changes!
So please tell me how to fix this, and if there's a way to recover my work from yesterday, because frankly speaking I'm starting to reconsider having my files stored at DB.
Kind regards,
WH
Dear Fiona,
got it to work (i.e. I can now open all files, though I did lose the one that didn't get synced). Turned out I had to allow for Smart Sync in the Dropbox preferences and for some reason this fixed things.
Found the solution here: https://www.dropboxforum.com/t5/Files-folders/Corruption-of-Excel-Files-saved-to-Dropbox/td-p/289813/page/2
Posted by another user. You might want to show this to other community managers as well so they can suggest this to other users with my problem.
So the fix required changing something with DB. I'd count it as "Dropbox corrupting my files", or at least as "Dropbox being misleading about what it's showing me in the Dropbox folder and not notifying me that I'm only seeing what's supposed to be there and not the actual file that is stored online" :/ .
Shouldn't the files be stored locally by default if someone doesn't enable smart sync? Is that what caused the problem?
Anyway. Thanks for your time and best,
Wojciech
- Fiona
Dropbox Staff
Thanks for reporting this experience WHardy.
I understand there is a corrupted file you have locally in your Dropbox folder and were not able to open or sync it. :slight_frown: The cloud had a previous version of this file saved. To solve your syncing issue you moved it to another location in Dropbox and this helped it sync. But it still has the previous date on the cloud and the other devices. Please feel free to correct me if I didn't get somthing right, so we can be on the same page with this.
:pushpin: Note that Dropbox doesn't have the ability to corrupt your files. Corruptions can be the result of third party app editions.
How does this file show locally when you try to open it? Is it corrupted in your local Dropbox folder and showing a functional previous version on Dropbox.com? :thinking:
Please add screenshots to show me what you see. Thank you!
Hi!
Thanks for your reply!
"I understand there is a corrupted file you have locally in your Dropbox folder and were not able to open or sync it. The cloud had a previous version of this file saved."
Yes, that's correct.
"To solve your syncing issue you moved it to another location in Dropbox and this helped it sync. But it still has the previous date on the cloud and the other devices. "
I copied it to check if it will change anything to another Dropbox folder. Now, the corrupted 'original' still has the new date. The copy has the same new date, BUT it synced on the PC (so I got a copy there too), but with the old date (Nov. 5).
So it's like the file is on both devices (both the copy and the original), but Mac has a new date corrupted file, and PC has an old date working file.
Dropbox.com also shows the older, working version. If I switch for the copied file to be stored locally (right-click -> intelligent synchronisation -> local), the date reverts to Nov 5 (the old date). I dare not try it with the new-date corrupt file.
I'm not sure which part would you like a screenshot of, so if anything's still unclear please let me know and I'll add it.
Thanks,
WH
- Fiona
Thank you for clarifying this for me WHardy .
If the corrupted version of the file was synced to Dropbox, you would see the file corrupted on the website as well. We cannot fix the corruption made by a third party app, nor tell which part of editing went wrong in the third party interface to result to this. To solve this, we would have to recover the previous functional version from your Dropbox version history.
Have you contacted Microsoft support for the Excel error you mentioned "Excel could not open the file ....xlsx due to an incorrect format or file extension." ? This error could be related to the corruption.
Is this corrupted file missing its file type indeed? If it does, please add the file type extension manually.
Test. :tools: We will need to make sure the device is syncing in general. Please drop a test file in your Dropbox folder and let me know if you see it syncing :arrows_counterclockwise:.
