Skip to main content

Notifications

Microsoft Dynamics CRM (Archived)

Refresh from CRM Excel Add-in not working

Posted on by Microsoft Employee

I have exported a Dynamic Worksheet from a system view in CRM by using EXPORT TO EXCEL --> Dynamic Worksheet from the available options. The workbook is saved to the local C:/ drive on my machine.

On selecting the Refresh from CRM option in the Data tab of the Ribbon, nothing happens - the data does not refresh. The Outlook for CRM add-in is installed on the machine and configured properly.

Upon selecting the Refresh All button adjacent, the following error message is written to the cells:

JavaScript required

JavaScript is required. This web browser does not support JavaScript or JavaScript in this web browser is not enabled.

To find out if your web browser supports JavaScript or to enable JavaScript, see web browser help.

(Organisation Name)

Sign in with your organisational account

Keep me signed in

Sign in

(c) 2013 Microsoft

 


The following KB article: https://support.microsoft.com/en-gb/kb/2556284, outlines a similar problem, with the exception that I do see the correct data on the file's first open. I can painfully work around the problem by using the advice outlined under the heading More Information.

Thank you in advance for any advice offered.

*This post is locked for comments

  • yleclerc Profile Picture
    yleclerc 1,545 on at
    RE: Refresh from CRM Excel Add-in not working

    The answer from Loz did the trick for us.

  • Loz Profile Picture
    Loz 2 on at
    RE: Refresh from CRM Excel Add-in not working

    Configure your Outlook Client using the External CRM URL.  Then you should be able to use the Refresh from Dynamics 365 button in Excel to refresh the data (rather than the Refresh All button).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Refresh from CRM Excel Add-in not working

    I have the same issue, please let me know the solution, thanks.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Refresh from CRM Excel Add-in not working

    We are experiencing this same issue. Has there been a resolution to this problem?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Refresh from CRM Excel Add-in not working

    Thanks for the help Drew. Unfortunately, this did not work and all of the settings in the guide are already configured here.

    After some more investigation, it looks like the connection string in Excel file is using our external facing URL rather than the internal one and because of this, the credentials are not being passed across automatically.

  • Suggested answer
    Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: Refresh from CRM Excel Add-in not working

    Hi Dan,

    Only suggestion I have (outside of opening a ticket with Microsoft) because I do see this is an issue that is out there that is noted in a number of blogs and with Microsoft's workarounds but I did see the following article that discusses the automatic login to CRM as part of the setup for dynamic worksheet.

    dynamicscrmcoe.com/dynamics-crm-2015-excel-dynamic-reporting

    I am wondering if you can configure this on one of the machines and see if it gets past the problem.  Sorry if this does not help but thought it would be worth a try.

    Thanks,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Refresh from CRM Excel Add-in not working

    Hi Drew,

    1. It is CRM 2016 On Premise with IFD configuration.

    2. This is not working for any other user that I know of. Across numerous machines I have tested, this feature is behaving the same.

    3. The Outlook client is working, we track 100's of emails every day and they all appear to be in the system.

    4. I have not tried reinstalling the CRM Outlook client; that is something I can do, but I assume it would mean that the installation is flawed on multiple machines.

    Thanks for your help so far Drew.

  • Drew Poggemann Profile Picture
    Drew Poggemann 9,079 on at
    RE: Refresh from CRM Excel Add-in not working

    Hi Dan,

    Thanks for the details!  Other questions, sorry:

    1.  CRM 2016 On Premise with IFD configuration or CRM Online?

    2.  Is this working for any other users in your organization or not working for anyone or is the issue tied to this machine?

    3.  Have you checked if the Outlook client is working at all?  Can you track emails, is it showing contacts that are tracked in CRM, etc.?  You had mentioned it was properly configured so maybe the answer is "yes" here.

    4.  Have you tried to reinstall the CRM Outlook client?

    Thanks,

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Refresh from CRM Excel Add-in not working

    Hi Drew,

    The operating system is Windows 10 on the latest stable build, the version of Outlook and Excel is Office 2016 Professional, and the browser typically integrated with both applications is Internet Explorer. We have set Microsoft Edge to redirect to Internet Explorer when using Dynamics CRM.

    I have checked my security settings, and scripts including .NET, ActiveX, and JavaScript is enabled (should only need the JavaScript). I have used: isjavascriptenabled.com to test JavaScript in the browser.

    Thanks,

    Dan.

  • EmployeeOcta Profile Picture
    EmployeeOcta on at
    RE: Refresh from CRM Excel Add-in not working

    Make sure to enable the javascript in the browser.

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,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans