web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

[INFO] Edit in Excel does not always work on all list page

(0) ShareShare
ReportReport
Posted on by

Hello,

Just sharing an issue we lately did discover in Microsoft Support (CSS). The issue is that on some pages the Edit in Excel functionality does not work. Nothing happens despite clicking the Edit in Excel button in WebClient. There are no errors to be found in the application event log file and the configuration is 100% correct. The scenario can be reproduced in all supported releases of Dynamics NAV / Dynamics 365 BC where this functionality does exist. When your customers do report it to you as a partner, this may consume lot of your time to reproduce. 

We’ve narrowed it down to a specific scenario when a web service for a page is already defined in Web Services and not Tenant Web services. This can happen if AL code inserts a record into Web Services directly (demo data, or other setup code). We rely on Tenant Web Services specifically to support SaaS  (D365 BC) scenarios, as we generate the service dynamically when a workbook is requested (and a service doesn’t already exist). In SaaS (or some other multi-tenant setups), it’s possible that we cannot write to Web Services, so we use Tenant Web Services to look up the web service to use.

Workaround: For web services backing the impacted pages, try un-checking ‘All Tenants’, moving to a different record to trigger the modify event, then check it again. This will populate the Tenant Web Services table and should allow the impacted pages to complete the workbook generation process.


1541.Capture12.PNG

CSS did raise an request for hot fix and we will soon provide a fix in a cumulative update. Hopefully the workaround will get you going. 

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Marco Mels Profile Picture
    on at

    Answered.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans