Dynamics Community Forum Thread Details

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

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