Excel export with cell "comments" - how to get rid of them?

(0) Share

Report

Posted on by Community Member

We recently upgraded to 7.0.2. When that happened, all Excel exports now have what appears to be cell "comments", although in the true Excel sense, they are not actually cell comments. The text is a description of the field type in CRM and is distracting when viewing the data in Excel. Does anyone know if there is a CRM setting to prevent this from happening? 2 examples below.

We are in CRM 2015 on premise.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Jason M. Cosman 5,234 Moderator on at

Like (0)

Report

Hello ABSTech;

I apologize but the images you tried to post didn't; could you please try to upload them again?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Good catch and thank you, Jason. I just posted 2 screenshot pictures.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi

Did you get an solution to this? We have recently upgraded to CRM 2016 and users are getting the same issue with reports exported from the system.

Thanks

Anna

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

We found a manual workaround in Excel, but we have not figured out an automated way to prevent the CRM export from including the cell data in Excel.

After you export and open the Excel file, select the entire sheet, then go to Data --> Data Validation --> Input Message --> Uncheck the box "Show input message when cell is selected"

I can't find a way to have that box unchecked by default. If you figure it out, please post how you did it.

Was this reply helpful? Yes No