Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Export to Excel & Refresh from Dynamic

Posted on by 545

Hi All,

   I have multiple records having currencies values like 120 & 123.31 When I export these to dynamic worksheet, from views I am getting 120.00 & 123.31 which is fine, but when I refresh using dynamic crm option in the excel, the value of 120.00 is remains same, where as other becomes 123,31 Can anybody explain me the reason behind it & also offer solution.    

*This post is locked for comments

  • ganesh198715 Profile Picture
    ganesh198715 545 on at
    RE: Export to Excel & Refresh from Dynamic

    Hi Scott,

         It works when I make changes in my system, but it isn't working when I make changes in formats of CRM.  

  • Verified answer
    ScottDurow Profile Picture
    ScottDurow 50,177 on at
    RE: Export to Excel & Refresh from Dynamic

    This is usually due to a miss match of number formats between your local computer and CRM user settings. Check that the number formats are the same.

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!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans