locked
Field description in comments in excel cells after Export to excel from MSCRM - UPDATED RRS feed

  • Question

  • Hi,

    Does anyone know if there is a way of getting rid of the comment/tooltip from the columns in excel after you export to excel from MSCRM online, everytime I move to a column there is a comment that pops up with a description of what the column is, it is in the way of users.

    How to replicate problem:

    1. Export any records from MSCRM online to Excel
    2. Click Enable Editing button in excel
    3. Select any cell that contains data, this is where the data comes up

    Best regards,
    Halldór


    Halldór Jóhannsson

    I looked at it more closely, this is a problem with "Data Validation" and can be removed on a sheet by sheet case...

    • Select the whole worksheet
    • On the Data tab, in Data Tools, click Data Validation
    • In the Data Validation window, click Clear All and then OK

    Does anyone know of a way to disable "Data Validation" when exporting to excel so users do not have to do this for every document they export?



    Friday, November 18, 2016 11:40 AM

Answers

  • This is a workaround for the problem, every user needs to do this everytime though.

    This is a problem with "Data Validation" and can be removed on a sheet by sheet case...

    • Select the whole worksheet
    • On the Data tab, in Data Tools, click Data Validation
    • In the Data Validation window, click Clear All and then OK


    Halldór Jóhannsson

    Tuesday, November 22, 2016 11:07 AM

All replies

  • Any one, any ideas?

    Best regards
    Halldór


    Halldór Jóhannsson

    Monday, November 21, 2016 10:00 AM
  • This is a workaround for the problem, every user needs to do this everytime though.

    This is a problem with "Data Validation" and can be removed on a sheet by sheet case...

    • Select the whole worksheet
    • On the Data tab, in Data Tools, click Data Validation
    • In the Data Validation window, click Clear All and then OK


    Halldór Jóhannsson

    Tuesday, November 22, 2016 11:07 AM