web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Check out the Community Spotlight Video Series
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / Automatic Update in Ex...
Service | Customer Service, Contact Center, Fie...
Suggested Answer

Automatic Update in Exported Excel Report

(0) ShareShare
ReportReport
Posted on by QK-27040914-0 2

We use Dynamics D365 CRM to record our support cases. I am able to extract details of my cases  in excel format. I need to know whether there is a way to auto sync excel file without manually exporting it every day?

 
 

 

 

 

 

 

I have the same question (0)
  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Hi Partner,
    Export your app data to an Excel dynamic worksheet to get the most up-to-date information from your app.
    --On the command bar, select the Export to Excel menu and then select Dynamic Worksheet.
    When you export your data to an Excel dynamic worksheet and then make changes to your data in the app, you can use the refresh feature in Excel to get the latest information from the app.
    I hope you can mark my answer verified if it is helpful! If you have any questions, please feel free to contact me.
    Regards,
    Leah
  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    Has the issue been resolved?
    Have there been any updates? Please feel free to ask me any questions you may have!
    If it has been resolved, can you mark the response as an answer?
  • QK-27040914-0 Profile Picture
    QK-27040914-0 2 on at
    Hi Leah
     
    Apologies for late response. Dynamic Worksheet option is not functioning for me. Refresh data removes all information from excel file. I have gone through below article but it is also not helping me in my scenario.
     
     

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

News and Announcements

Check out the Community Spotlight Video Series

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Muhammad Shahzad Shafique Profile Picture

Muhammad Shahzad Sh... 69 Most Valuable Professional

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 25 Most Valuable Professional

#3
Ayesha Wajahat Profile Picture

Ayesha Wajahat 16

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans