Skip to main content

Notifications

Microsoft Dynamics 365 | Integration, Dataverse...
Suggested answer

customise advanced find export excel format

Posted on by 45

hi, sir and madam,

my crm is on premise version
Microsoft Dynamics® CRM 2015
(7.0.3.150) (DB 7.0.3.150)

after i installed patch into it.

user reported the exported excel format from advanced find is different to the format before patch applied.

especially the datetime column, when use clicked filter button on excel, it needs to compute much more time. he wants previous record back.

how to solve this issue. can the column format on exported excel customised before exporting it?

thank you

  • Suggested answer
    RE: customise advanced find export excel format

    surely,,Your operating system region settings (in Windows, Control Panel > Region) and Dynamics 365 Customer Engagement (on-premises) organization language and locale (Settings > Administration > System Settings > Formats tab > Current Format) should be the same.

    docs.microsoft.com/.../export-excel-dynamic-worksheet

  • LuHao Profile Picture
    LuHao 40,872 on at
    RE: customise advanced find export excel format

    Hi stephenyip,

    Can you check if the Format in the system settings and personal settings are the same?

    pastedimage1596187500229v1.png

    pastedimage1596187522193v2.png

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans