News and Announcements icon

Dynamics 365 CommunityForums Finance forum Issues with Excel inte...

Finance forum

Unanswered

Issues with Excel integration

(1) Share

Report

Report

Posted on by Gaute K

296

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?

Categories:

Administration and Setup

All responses Img

All responses (3)

Answers Img

Answers (0)

Kevin Xia Microsoft Employee on at

Like (0)

Report

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

Like (0)

Report

Issues with Excel integration

I would guess that this is happening post 01/01. If yes, highly likely related to this:

Details for issue 871623 (dynamics.com)
André Arnaud de Cal... 290,552 Super User 2024 Season 2 on at

Like (0)

Report

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?

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2

Martin Dráb 228,552 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans