Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP forum (Archive) / exporting to excel cho...
Microsoft Dynamics GP forum (Archive)
Unanswered

exporting to excel chooses wrong license in excel

(1) ShareShare
ReportReport
Posted on by CU18061209-0 1
I have a user who has MS Office 365 installed on their computers. Let’s say the ID that shows up when you open Excel is user1. When they log into MS NAV they log in as Joe. When I export or send to Excel it opens Excel and wants to use the account of Joe which does not have an office license. Usually, it will just open Excel using whatever license has
been authenticated on that PC. We use Nav 2016 and Office 365. How do I get it to stop trying to use the Joe account in Excel?
Categories:
Other
  • Judy Profile Picture
    Judy Microsoft Employee on at
    exporting to excel chooses wrong license in excel
    Hi, I think this is by design. When the user logs into NAV and opens Excel, their account is used by default.
    However, by using the Business Central add-in for Excel, users can use their Business Central username and password to edit and view data in Excel without an additional Office license.
    You may refer to the following link:

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

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Blog subscriptions now enabled!

Follow your favorite blogs

TechTalk: How Dataverse and Microsoft Fabric powers ...

Explore the latest advancements in data export and integration within ...

more Community News

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,860 Test role Public

#2
Ludwig Reinhard Profile Picture

Ludwig Reinhard Microsoft Employee

#3
Martin Dráb Profile Picture

Martin Dráb 225,155 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans