Tech Support > Microsoft Windows > Windows CRM > CRM Numeric Fields change to General when exported out to Excel
CRM Numeric Fields change to General when exported out to Excel
Posted by kathyc on May 4th, 2007


Hello,

I have exported to Excel a set of Invoice Records (Invoices This Month)
When I open the Excel file, I notice that the Number type fields in CRM have
now been changed to the General type field.

Is there a way to fix this?

Posted by MD on May 4th, 2007


Hey Kathy,

Excel doesn't retain CRM data types. When you export a CRM View, it's as if
you do a Paste Special --> Values. A simple workaround is to export the view
as a Dynamic Worksheet or PivotTable, then set your formatting. The
PivotTable or Worksheet will refresh with the proper formatting each time you
open the workbook.

"kathyc" wrote:


Similar Posts