cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Known issues updated. Learn more

default

yes

Highlighted

Issue with Excel - "Excel file format is not valid"

Level 3

Excel file format is not valid.  Please help as unable to open Excel.

19 Replies

Re: Issue with Excel files

Super User II
You need to provide more information about the problem you're having. Are you opening Excel files from the Dropbox folder on your desktop, or the Dropbox website? Does the problem only occur with files in your Dropbox folder, or elsewhere on your computer as well? Have you dragged one of the problem files out of your Dropbox to your desktop and tried to open it from there? Mac or PC? Office version? etc.
Reply
Loading...

Re: Issue with Excel files

Level 3

I am trying to open Excel from both but neither are opening.  Desktop error says "file format is not valid".  I edited the document on 2 September with no issues.

Reply
Loading...

Re: Issue with Excel files

Dropboxer

Hey @flew

Hmmm... Mere guess here, since I've encountered the same error in the past. 

If it's an .xls file, you'll probably need to modify (:repair) the file extension to .xslx. If you run a google-search, you'll easily find some articles that will walk you through the process as well. 

If this persists, would you mind including a screenshot (omitting personal info) of what you're seeing in your next post here, so that I check it with you? 

Thanks! 

 


Jane
Community Moderator @ Dropbox
https://dropbox.com/support


 


Heart Did this post help you? If so please give it a Like below. 
White check mark Did this post fix your issue/answer your question? If so please press the 'Accept as Best Answer' button to help others find it.
Arrows Counter Clock Still stuck? Ask me a question! (
Questions asked in the community will likely receive an answer within 4 hours!)

Reply
Loading...

When doing a Save as... with a CSV to .xlsx in Excel 2016 to dropbox. Shows Up as corrupted.

Level 6

After checking throughally it seems when this is done in Excel 2016, it saves as a CSV format but with a .xlsx file extension. Making Excel think it's corrupted when it's just under the wrong file extension. Seems to be an issue exclusively with using the dropbox saving function in office.

 

Can someone else test this out? I am unsure why this is happening this way. The workaround is simple, save locally instead of with dropbox. But feels like a bug someone should be made aware of.

Reply
Loading...

Re: Issue with Excel files

Level 6

Try renaming to .csv and doing save as outside of Dropbox. Currently dealing with an identical issue and found it was still in it's original format when used the dropbox saving function in office 2016. Making it seem corrupted when it was just something in the process changes the file extension but not the actual format.

Reply
Loading...

Re: When doing a Save as... with a CSV to .xlsx in Excel 2016 to dropbox. Shows Up as corrupted.

Super User II

Brandos wrote:

it saves as a CSV format but with a .xlsx file extension


I'm seeing the opposite. When I do a Save As, specify Dropbox as the location and select CSV as the file type, it's saving the file in the XLSX format with a .csv file extension. Saving to the Dropbox folder directly, without using the Save to Dropbox functionality, the file is saved correctly.

Reply
Loading...

Re: When doing a Save as... with a CSV to .xlsx in Excel 2016 to dropbox. Shows Up as corrupted.

Level 6

So it seems it's a problem with the save as function in general in excel not just any particular file format. The function of doing a save as to a different format is not working correctly when saving to dropbox.

 

Wish we could get some support members to look at this and give us an idea on why this is happening and what fix there is if any.

Reply
Loading...

Re: When doing a Save as... with a CSV to .xlsx in Excel 2016 to dropbox. Shows Up as corrupted.

Dropboxer

Merging several posts with the same description. 

 


Jane
Community Moderator @ Dropbox
https://dropbox.com/support


 


Heart Did this post help you? If so please give it a Like below. 
White check mark Did this post fix your issue/answer your question? If so please press the 'Accept as Best Answer' button to help others find it.
Arrows Counter Clock Still stuck? Ask me a question! (
Questions asked in the community will likely receive an answer within 4 hours!)

Reply
Loading...

Re: When doing a Save as... with a CSV to .xlsx in Excel 2016 to dropbox. Shows Up as corrupted.

Level 6

Do we have any new information on this issue. I don't see any solutions being presented. All I have is workarounds.

Reply
Loading...
Error Messages

Have a question? Our Dropbox Community is here to help!

Post your question or search for an answer below.


Learn more about using the Community by reading our Community Guidelines.


Hi anonymous,

If you need more help you can log a ticket with our Support Team here (expected response time 24 hours), or contact us on Twitter or Facebook.

For more info on available support options, see this article.

If you found the answer to your question, please 'like' the post to say thanks to the user!

Issue with Excel - "Excel file format is not valid"
9,966 Views
19 Replies
9 Likes
Solved! : See solution
Who's talking
Top contributors to this post