Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Open in Excel keeps di...
Finance | Project Operations, Human Resources, ...
Unanswered

Open in Excel keeps disappearing frequently

(0) ShareShare
ReportReport
Posted on by MYGz 1,862

Hi,

Open in Excel keeps disappearing frequently. Then I follow multiple steps and one of them seems to fix it but I don't know which one:

1. Reload system Templates in Org Administration > Setup > Office Integration > Document Templates

2. Reinitialize App parameters. Sys Administration > Setup > Office App parameters.

As you can see below the open in excel is not there although I haven't done any change to the system regarding it:

pastedimage1644912201271v1.png

What is the reason it keeps disappearing? Is it the auto enforced update of UAT and Prod environments by Microsoft when the version is below 2 version?

And what is the fix?

Update1: Although I found out now that it's visible in the other drop down but not in the above.

pastedimage1644912338594v1.png

Update2: I tried opening the General Journal line entry and this is the error I'm getting:

Please connect to the internet to use Open in Excel.

pastedimage1644912583874v1.png

Update3: Getting this error when try to reinitialize:

pastedimage1644913032131v1.png

Best Regards, 

  • WUY Profile Picture
    WUY 27 on at
    Open in Excel keeps disappearing frequently
    system administration > setup > client performance options
    make sure that the checkbox "internet connectivity enabled" is activated
  • tnaess Profile Picture
    tnaess 25 on at
    Open in Excel keeps disappearing frequently
    Also having the same issue for different users at different times. No updates performed in our PROD where this occurs. It magically fixes itself during night hours, so the next day everything is working again. For one user we logged of D365F, opened an InPrivate browser session and logged in, then the "Open in Excel" function was available. The user then logged of and opened a "normal" browser session, then everything worked as it should. Curios on the reasaon for this behavior.
  • James Majcen Profile Picture
    James Majcen 2 on at
    Open in Excel keeps disappearing frequently
    Having the same issue. Totally sporadic. 
  • MYGz Profile Picture
    MYGz 1,862 on at
    RE: Open in Excel keeps disappearing frequently

    JackTurner90 I haven't faced this issue for long now. I just used to do couple of steps that I have mentioned in the Question and some of it did the job sometimes and not other times. It would be trial and error. Or else you can raise a ticket to microsoft on LCS.

  • JackTurner90 Profile Picture
    JackTurner90 15 on at
    RE: Open in Excel keeps disappearing frequently

    Hi, did you find a resolution for this, i am experiencing the same issue for multiple users.

    Any advice or answers would be great

  • MYGz Profile Picture
    MYGz 1,862 on at
    RE: Open in Excel keeps disappearing frequently

    I suspect it is related to Environment Refresh actions. And that Sys Administration > Setup > Office App parameters > Reinitialize seems to fix the issue. But would be helpful if there's any official documentation for this.

    I will confirm once I notice it again just before&after the Env Refresh action.

  • MYGz Profile Picture
    MYGz 1,862 on at
    RE: Open in Excel keeps disappearing frequently

    This is cloud instance. I checked after sometime and one of the steps that I performed above in the question seemed to resolve the issue. Now I can see the options. But which step it was I am not sure.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,661 Super User 2024 Season 2 on at
    RE: Open in Excel keeps disappearing frequently

    Hi MYGz,

    Is this a cloud instance or are you running on-premise? Did it work before without issues?

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! 🥳

Get Started Blogging in the Community

Hosted or syndicated blogging is available! ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 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