Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM forum / How to show unhidden s...
Microsoft Dynamics CRM forum
Suggested answer

How to show unhidden system fields in excel

(1) ShareShare
ReportReport
Posted on by CU21100958-1 4
Hi 
 
My requirement is when export to excel from mscrm then those three system fields(Do not modify) I need to show in excel from mscrmndata
Categories:
Development / Customization / SDK
  • Collins Limo Profile Picture
    Collins Limo 6 on at
    How to show unhidden system fields in excel
    Hello, 
    After exporting the file from CRM and opening it, I would simply go to format then select hide & unhide dropdown under visibility then choose unhide columns. 
    This would show cell A then you can drag the rest of the columns to the right to show both C and D. 
    Check the screenshot below. 
     
    I hope this helps.
     
    BR,
    Collins
  • Suggested answer
    Amit Katariya007 Profile Picture
    Amit Katariya007 6,827 Moderator on at
    How to show unhidden system fields in excel
    Are you talking about Column A, B , C in the excel which is hidden by default? Or some Entity fields ?
     
    If it is first one then it is standard CRM format which will make this fields as the hidden because it will be used by CRM during import. As it have information about the Each row.
     
    You can download and manually unhide, if you want to see.
     
    If it is entity fields then you will have to add those fields in the view and export. You can user Fetch XML XRMTool if you need more custom query...
     
    Thank you,
    Amit Katariya 
  • Suggested answer
    Muhammad.Affan Profile Picture
    Muhammad.Affan 2,667 on at
    How to show unhidden system fields in excel
    Hi There,
     
    You need to ensure that those fields are part of the view that you're using for the export.
     
    Refer this link to add columns (system fields) to your view:
     
    Thanks
    Affan
    If my suggested answer has helped, please mark it as verified.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Replay: Dynamics 365 Community Call ERP Edition | October 9, 2024

Another great gathering of our Community!

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

More Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,628 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,914 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,150

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans