Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Issues with Excel integration

(1) ShareShare
ReportReport
Posted on by 312
 
A user cannot see the /Open in Excel/ options while in the /LedgerJournalTable3/ form. However, when I add the exact same security roles and legal entity restrictions on my test user, I can see and access them.
 
The strange thing is that they were visible for the user previously, and we managed to retrieve them by resetting the usage data for his user. However, the next day, they were gone again. 
 
Any suggestions for how we can solve this?  
 
  • Kevin Xia Profile Picture
    Microsoft Employee on at
    Issues with Excel integration
    Hi,
    If you're not sure why this is happening, you can check your system settings first:
    Has the system been custom-developed? Does the user have the necessary permissions to open Excel and access a specific form?
    Best regards,
    Kevin
  • MayurNair Profile Picture
    on at
    Issues with Excel integration
    I would guess that this is happening post 01/01. If yes, highly likely related to this: 
  • André Arnaud de Calavon Profile Picture
    292,688 Super User 2025 Season 1 on at
    Issues with Excel integration
    Hi Gaute,
     
    I haven't seen this issue before. Have you checked if the data entity is part of the security role? How is the behavior with other users having the same role assignments? If you reset the usage data again, will the option then be visible?

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,688 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,643 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans