- 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
- problem opening excel-word-access (office files in general ) double clicking in Windows Explorer (Home and office) by Fran Vázquez
- Change NVARCHAR fields (Windows CRM) by LisaNic
- Display fields from Excel within CRM entity (Windows CRM) by Sam - Inogic
- Exported data to Excel (Windows CRM) by kathyc
- Change regarding fields (Windows CRM) by Kevin Wilson

