Export Failure Rows creates blank Excel sheet CRM 2011

One of my team mate was trying to prepare and import the data for a client and ran into an weird issue.

The import was not successful and had a few failure rows. Now in CRM 2011 we have an option to “Export Failure Rows” which will actually go ahead and export the data of those rows that failed during the import.

To our surprise this feature didn’t export failure rows instead created blank Excel sheet in CRM 2011 which is of no use. So, if you are also running into such issues, no worries, here’s a quick dirty way out.
Continue reading