Export to excel issue

(0) Share

Report

Posted on by Community Member

when I perform export to excel dynamics spreadsheet in MS CRM 2013, an XML file is being opened. Also when export excel static option is being performed, there is the below error

"The file format and extension of file does not match" error

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Karth on at

Like (0)

Report

Do you have Excel installed on your machine?

Was this reply helpful? Yes No
Suggested answer

Hosk on at

Like (0)

Report

Have you tried exporting and then saving the file before you open it.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

You can't import excel file if you saved it as ( dynamics spreadsheet).

Before export to excel you should mark it as (Make this data available for re-importing by including required column headings)

Then add your data and import.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The error that I mentioned is being displayed when the excel is being saved.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

First of all. CRM for Outlook should be installed.
To view and refresh dynamic data, Microsoft Dynamics CRM for Outlook must be installed. If it is already installed and configured, click "Refresh from CRM" to sign in to Microsoft Dynamics CRM. If you do not want to be prompted again to sign in, click "Save my email address and password" on the Sign In page.

Second:
Export view should contain required fields... Problem could be in this way...

Was this reply helpful? Yes No
Verified answer

Alan Smith on at

Like (0)

Report

Sree;

I think perhaps the information below will resolve your issue. I think that I got it some time ago from these forums, but don't have a link back to that original information.

Getting Rid of the CRM Export to Excel Warning Message

Per Computer – You can easily get rid of this warning using a simple registry change on your computer. The following instruction are for Excel 2010. If you have 2007, the only change would be the location of the registry folder will be …\Microsoft\OFFICE\12.0\EXCEL\SECURITY. Normal warnings apply—don’t modify your registry unless you know what you are doing.

   1. Open your Registry (Start -> Run -> regedit.exe)
   2. Navigate to HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\OFFICE\14.0\EXCEL\SECURITY
   3. Right click in the right window and choose New -> DWORD
   4. Type “ExtensionHardening” as the name (without the quotes)
   5. Verify that the data has the value “0″

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you Alan. This post helped

Was this reply helpful? Yes No