Need to see if your shared folder is taking up space on your dropbox 👨💻? Find out how to check here.
Forum Discussion
Solved
Issue with Excel - "Excel file format is not valid"
Excel file format is not valid. Please help as unable to open Excel.
I think I found the solution.
If you disable the office dropbox add-in the problem doesn't seem to occur anymore. You can still save to dropbox via file explorer making it redundant anyhow.
to do this, open excel, go under file, Choose "Options", and navigate to "add-ins".
From there locate the Dropbox Add-in and right click, select "disable".
Should stop it from being an issue.
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.
Rich
Super User II
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.
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.
- Jane
Dropbox Staff
Merging several posts with the same description.
Do we have any new information on this issue. I don't see any solutions being presented. All I have is workarounds.
There is a huge number of MS Excel issues and errors that stops users to access their work and waste their time and I am among those users. While I was working a message appears that’s says Excel file is not in a recognized format.
Oh no…Excel file is not recognizing the format, how will I work now. Yeah, the wordings matched with yours. But I found the solutions to fix this issue, you want to know how? Look below:
- Utilize the MOC.exe File
- Open file from within the Excel
- Try disabling the Add-ins
These are just the starters get full information on Excel File Format Is Not Valid.
- Found same issue today this helped Thanks.
Definately an issue with the save to dropbox add-in. Saving a csv to xlsx , using windows explorer to browse to the dropbox folder path has no issues.Hi there
I am all of a sudden having the same problem, using Excel 2016 pro. I have removed the dropbox add in adn tried saving in different formats. This is a real problem for a company that uses spreadsheet after spreadsheet, any updated fixes welcome. Thanks
- MarkI can almost certainly say the issue is not Dropbox, but, the fact that the file structure is too big.
Windows can usually only access files or folders when the total number of characters is less than 250. So, without counting I think thats the issue. You need to make the folder structure smaller (e.g. 'Bromgrove Iraq Ltd' to maybe just Bromgrove and next way to 'Out of Country' etc.)
About View, download, and export
Need support with viewing, downloading, and exporting files and folders from your Dropbox account? Find help from the Dropbox Community.
