web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / excel cannot open the ...
Microsoft Dynamics GP (Archived)

excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

(0) ShareShare
ReportReport
Posted on by Community Member

The client is using Microsoft Dynamics GP 2015 and Office 2013. The problem is when we try to export the customer list we get the following error, but it works fine when vendors list from SmartList

excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

I have already checked there are no viruses on the server.

Need helping in resolving this problem.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    There is an article similar to your issue. It could be malware affected on the machine.

    Refer the link:

    blogs.technet.com/.../quot-cannot-open-the-file-because-the-file-format-or-extension-is-invalid-quot-opening-office-files.aspx

  • Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    Shan,

    Thanks, but I already saw that article and I downloaded it and there is no malware or virus on the server.

  • Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    Can you try repair the Microsoft Office?

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    Hi Tracy,

    I have seen this a few times and it seems like it is always caused by a character in the export dataset that excel doesn't want to recognize. It can be hard to chase down the record that is causing it but it is possible. Occasionally simply refreshing the smartlist and exporting again will "fix" this.

    Regards,

    Kirk

  • Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    Did run the repair and it didn't resolve the problem.

  • Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    I did the refresh on the smartlist and it didn't fix it.

  • Suggested answer
    KirkLivermont Profile Picture
    KirkLivermont 5,985 on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    Hi Tracy,

    Have you seen this post? It sounds like it might be the same issue you are experiencing.

    community.dynamics.com/.../129066

    If the refresh didn't work I believe the next step is to isolate any special characters in the returned dataset.

    Kirk

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    Thanks to everyone for their help on this matter. The client had funky characters beyond @!/. They have used a font that put some special letter in the data and excel wouldn't allow the data to export. It exported to Word because the fonts are in Word.

    Again thanks.

    Tracy

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    If the Excel file is corrupt and you want to repair it, you should try few easy manual tricks before purchasing any paid software. The manual tricks don't require any 3rd party tool or any other cost. You just need to use MS Excel program, that's it. You can try the following things: 

    • Open and Repair, a built-in trick in MS Excel program
    • Data extraction
    • Using SYLK (Symbolic) format

    Refer to this blog post for complete information - Few Easy Tips & Tricks to Repair Excel File Manually

    I hope the shared information would be helpful here.

  • Community Member Profile Picture
    Community Member on at
    RE: excel cannot open the file .xlsx because the file format or file extension is not valid. verify that the file has not been corrupted and that the file extension matches the format of the file.

    Resolve any kind of issues related to MS Excel files, by using the manual and a third party solution given at- msofficerecovery.blogspot.com/.../resolving-excel-error-file-error-data-may-have-been-lost.html

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans