Hi,
We're having an issue when trying to edit the Web Query on an Excel Dynamic Worksheet with data from CRM 2016. This has worked in the past but has not recently. We follow the following steps.
- Navigate to an entity view in CRM
- Export as a Dynamic Worksheet to Excel
- Open the exported worksheet
- Click on the Data Tab - Connection
- Select the Workbook Connection
- Click on the Definition Tab
- The Connection type is Web Query, which cannot be changed
- Click on Edit Query
- We receive a standard Dynamics 365 error "Try this action again. If the problem continues, check the Microsoft Dynamics CRM Community for solutions......."
Any help appreciated.
Thanks