Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Excel refrech gives a strange date error RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello

    Export to dynamic worksheet works as expected. However if we do a Refresh from CRM some of the date values are changed from 15-12-2015 to 42353.25 and others are displayed as ######.

    Not sure if it is CRM or Excel that is doing this. Perhaps some format setting? Any suggestions?

    Thank you.    
    Wednesday, December 16, 2015 12:51 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Don, this is definitely Excel formatting values for you. 42353.25 is internal representation of 15dec2015 06:00, and ###### means the column is not wide enough to display what's in the cell. Check what format you set for the column that the dates are returned into, and what's your setting for 'Preserve cell formatting' in data range properties.
    Monday, December 21, 2015 8:51 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Don,

    Juz double click the at the column name where you want to see the date. 

    example : Double click at the highlighted place, when + symbol is seen.

    Regards, Rekha.J

    Monday, December 21, 2015 9:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Its excel, you'll need to update the column to display date in the format you want.

    Regards, Donna

    Monday, December 28, 2015 4:43 PM