Captain Redlaces Sewell reports that there is an issue in CRM 2015 update 1 when exporting to Excel. If you open the file directly from CRM, the table will not be correctly formatted.
What you need to do is save the document, then open the document from the save location. But do not to use the ‘Save and Open’ option offered by the download – it’s a trap!
To be sure – Save the exported file to your desktop – Close Excel – Then open the file from your desktop. –
Don’t use either the ‘Open’ or ‘Save and Open’ options that you’re tempted with. In the words of the sailors of old, ‘Here be Dragons’
Also – I should have highlighted the word “Desktop” –
If you save it to your default “downloads” folder, Excel still treats the file with as much contempt as if it were a Yankees fan in Fenway Park.
Scott – I am trying to download our reports in CRM 2015 sp1 but am only getting #VALUE! for my Revenue columns. I tried the suggest here but no change to the issue. Thoughts? I have heard this was something in the report code.
When I try to export to Excel, two columns with text are displaying the the GUID instead. I tried saving the file to my desk and then opening it in Excel but it didn’t work.