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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 general forum

Using Excel Online in CRM 2016 (On-Premises)

(0) ShareShare
ReportReport
Posted on by 87

Hi guys,

i want to use the feature of open excel online but on CRM on-prem there are any ways other than export excel and import it again 

online-excel.PNG

I have the same question (0)
  • Suggested answer
    Mahadeo Matre Profile Picture
    17,021 on at

    Hi,

    If you wan to modify data in excel without importing it back to CRM.. then use Dynamic Worksheet option.

    Here is some good information on dynamic worksheet

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

    www.magnetismsolutions.com/.../Exporting_Dynamic_Worksheets_to_Excel_in_Dynamics_CRM_2011.aspx

  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at

    Hi,

    You can also enable editable grid which you can use to update the records directly within CRM itself.

    Refer this:

    community.dynamics.com/.../configuring-editable-grids-in-dynamics-365

    www.youtube.com/watch

    Hope this helps.

  • Mebo Profile Picture
    87 on at

    Dear Mahadeo,

    thanks for reply "refresh from CRM" update the excel sheet from CRM but i want to update CRM from Excel sheet

    i need tool or work around instead of re import excel sheet to update the data

  • Mebo Profile Picture
    87 on at

    Dear Ravi,

    thanks for reply but i use CRM 2016 so can't use editable grid  

  • Mebo Profile Picture
    87 on at

    this is exactly what i want to apply:

    community.dynamics.com/.../what-if-analysis-using-excel-with-crm-online-2015-update-1

  • Mebo Profile Picture
    87 on at
  • Mebo Profile Picture
    87 on at

    www.youtube.com/watch;v=NZNvWz9xuZ0

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

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Dynamics 365 general

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans