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 :
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 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:
I have the same question (0)
  • Suggested answer
    Derek Albaugh Profile Picture
    on at

    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

  • Xavier Toney Profile Picture
    5 on at

    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
    on at

    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,

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 611 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 529 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 285 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans