Delete, edit, and organize
Solve issues with deleting, editing, and organizing files and folders in your Dropbox account with support from the Dropbox Community.
We have Dropbox for business and collaborate on a number of Excel files using Mac. Only one user at a time is permitted to access the file to avoid sync errors; all computers have installed the latest operating system, MS Office version.
We regularily encouter Excel files being saved to Dropbox becoming corrupt. Version history is used is used to recover the last stable version often losing work.
I have been on a number of threads that report the same issue, with no solution. This has been ongoing for a number of years and cannot replicate the specific circumstances in which to create the corruption. This is not an issue with MS Excel as the problem is isolated to Excel files save to Dropbox.
Has anyone got a explaination / solution for this happening?
Lusil
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.
Lusil
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.
I am having this same issue (a year later). I don't understand why the above was marked as a solution, as it doesn't offer a solution.
Moving the file to a local folder once it is corrupted does not work. There are no incompatible characters. In fact, the Excel files are able to be opened at least once. Then, at some later point become corrupted.
A screenshot of the error message is attached.
Hey there @kemjdm,
Is the file that you're trying to open currently synced "local" or is the file "online only" using smart sync in your Dropbox folder? You can clarify this by checking the sync icon next to the file in your File Explorer window.
Can you let us know if you're able to open the file correctly if you download the file from the website? Also, are you able to preview the file correctly on the website or do you also see an error there?
Let me know what you find - Thanks!
Daphne
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.
@Daphne wrote:Hey there @kemjdm,
Is the file that you're trying to open currently synced "local" or is the file "online only" using smart sync in your Dropbox folder? You can clarify this by checking the sync icon next to the file in your File Explorer window.
It's a synced local file.
Can you let us know if you're able to open the file correctly if you download the file from the website?
No. I get the same error message in Excel after I download it from the website.
Also, are you able to preview the file correctly on the website or do you also see an error there?
Let me know what you find - Thanks!
I *am* able to preview the file on the website. I can also open it with Microsoft Excel Online via the dropbox website.
That's somewhat of a relief that the files are not completely gone when this happens.
Hey @kemjdm,
Thanks for checking on that for me!
Can you check if there are any pending updates for your Excel software installed on your computer? Perhaps reinstalling the software might do the trick with resolving this error.
I hope this helps - Thanks!
Daphne
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.
My Excel installation is up to date.
@Daphne wrote:Hey @kemjdm,
Thanks for checking on that for me!
Can you check if there are any pending updates for your Excel software installed on your computer? Perhaps reinstalling the software might do the trick with resolving this error.
I hope this helps - Thanks!
Hey @kemjdm,
Since you're able to open this file with Microsoft Excel online but not through the local Excel installation on your computer, it seems like the issue might be related to the software you're using to open the file.
Can you check the steps in this Microsoft Support page here and let me know if any of the steps help with the issue?
Let me know how it goes - Thanks!
Daphne
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.
I had already tried repairing the file in Excel before posting to this forum. However, I did not know about the Protected View option in the OP on that thread:
1. Open Excel 2010.
2. Click on File > Options.3. Select Trust Center > Trust center settings.
4. Select Protected view.
5. Uncheck all the options under Protected View > OK.6. Restart Excel 2010 and try to open Excel documents.
Thank you! That fixed it.
@Daphne wrote:Hey @kemjdm,
Since you're able to open this file with Microsoft Excel online but not through the local Excel installation on your computer, it seems like the issue might be related to the software you're using to open the file.
Can you check the steps in this Microsoft Support page here and let me know if any of the steps help with the issue?
Let me know how it goes - Thanks!
I'm very happy to hear that solved the issue @kemjdm!
If you ever have any other questions or issues then you know where you can find us.
Have a great day - Cheers!
Daphne
Community Moderator @ Dropbox
dropbox.com/support
Did this post help you? If so, please give it a Like below.
Still stuck? Ask me a question!
Tips & Tricks Find new ways to stay in flow or share your tips on how you work smarter with Dropbox.
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!