You’re offline. This is a read only version of the page.
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
When given the option to log in to activate Office the following error is presented as well
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
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,
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!
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (