Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Dynamic Great Plains w...
Finance | Project Operations, Human Resources, ...
Suggested answer

Dynamic Great Plains will not open in excel or word ask to activate Office

(0) ShareShare
ReportReport
Posted on by Xavier Toney 5

Hello all.

I am working with a customer and when attempting to open a report from Dynamic Great Plains in Excel or Word, they are prompted to log in with other MSFT credentials in order to activate Office. Upon doing so they receive alert stating "content within this application coming from the website listed below is being blocked by Internet Explorer Enhanced Security Configuration.

Website: About: Internet

Screen-Shot-2022_2D00_07_2D00_26-at-4.22.34-PM.png

When given the option to log in to activate Office the following error is presented as well 

Screen-Shot-2022_2D00_07_2D00_26-at-4.22.34-PM.png

Troubleshooting completed - 

1) Windows updates - Successful - no change
2) Driver/ firmware updates - Successful - successful - no chanhe
3) Repair office - successful - no change
4) Uninstall/ reinstall office - successful - no change
5) Allow all cookies via Chrome and internet options - successful - no change
6) Log out/ in to Office - no change
7) Clear browser cache (all time) - no change
8) remove remote desktop connection and re add - no change

9) run windows updates via excel > account - successful - no change

10) add URL to sites that always allow cookies - successful - no change

11) add URL to trusted sites - no change

Categories:
Microsoft Dynamics GP
  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamic Great Plains will not open in excel or word ask to activate Office

    I don't know of any issues we have with exporting SmartLists to Excel. To verify, if you haven't already, see if you get the same message/error when exporting our default SmartList reports like Accounts or something like that.

    You also mentioned this customer uses GP via Remote App, try removing Remote App from the equation and test, whether just using Remote Desktop Connection to connect to the server that GP is installed onto or install GP on another machine or SQL Server and have the user test.

    We sometimes see behavior when going through other technologies like Citrix, RemoteApp, GP as a published app, etc., so that we try treat them like third party products where we try to remove them from the testing to make sure they're not part of the issue being seen.

    Another test you can do is, on one machine where GP is installed, have all users log out of GP and then rename the GP directory from something like this >> C:\Program Files (x86)\Microsoft Dynamics\GP2018\ to be something like this >> C:\Program Files (x86)\Microsoft Dynamics\GP2018OLD\

    Then in Control Panel > Programs and Features, run a Repair against the GP install which will completely re-create the GP directory under the original name, minus any third party products, customizations nor forms/reports dictionary files.

    Launch GP from this 'new' GP directory and login as 'sa'. See if you can now export our default SmartLists to Excel or not.

    --if you do not get the error, then we'd want to add back any forms/reports dictionary files first and test again. Then if still no error, add back any third parties or customizations, one by one, testing after each one is added, to make sure you can still export SmartLists to Excel or not. When the error returns, then that is potentially the cause of the issue being seen.

    Let us know if you have any questions.

    Thanks,

  • Xavier Toney Profile Picture
    Xavier Toney 5 on at
    RE: Dynamic Great Plains will not open in excel or word ask to activate Office

    Hey Derek! Thank you for your reply,

    Type of list: Smartlist, issue occurs when attempting to open the export into Excel or Word.

    Does this error only occur when opening/saving reports, or elsewhere in GP?

    - The issue only occurs when attempting to export the data into Excel or Word.

    I'm also curious, if you disable the Internet Explorer Enhanced Security Configuration, as a test, on the machine that Dynamics GP is on, does that change the error or does it remain the same?

    -  Have not tested this as I am not entirely familiar with using Server Manager, I will need to check with my Lead to see if I am able to do so!

    Also, do you get this message on multiple machines with GP installed, or do you only have GP installed on a terminal server type environment?

    - Our customer access GP via Remote Desktop App, this seems to be an isolated issue, other customers able to export to Excel or Word without error.

    I also wanted to verify, what version of Dynamics GP are you on, i.e. 18.x?

    - We use Dynamic Great Plains 2018

    Additional troubleshooting -

    Reset PC - no change

    Please let me know if you need any other information!

  • Suggested answer
    Derek Albaugh Profile Picture
    Derek Albaugh on at
    RE: Dynamic Great Plains will not open in excel or word ask to activate Office

    When you mention reports, are you talking about exporting SmartLists into Excel and/or saving reports to a Word file type?

    Does this error only occur when opening/saving reports, or elsewhere in GP?

    I'm also curious, if you disable the Internet Explorer Enhanced Security Configuration, as a test, on the machine that Dynamics GP is on, does that change the error or does it remain the same?

    Also, do you get this message on multiple machines with GP installed, or do you only have GP installed on a terminal server type environment?

    I also wanted to verify, what version of Dynamics GP are you on, i.e. 18.x?

    Let us know the above information and that may help us find something....

    Thanks

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey Pt 2

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans