Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Answered

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

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. 

Categories:
  • Verified answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: [INFO] Edit in Excel does not always work on all list page

    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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,645 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans