Repro Steps
> Launch CRM
> Navigate to Workspace
> Click Activities
> Export All Activities to Dynamic Worksheet- Open dynamic worksheet
> An xlsx file will download
> Open the exported worksheet
> Click Data Tab
> Click on Connection
> Select the Workbook Connection
> Click on Definition Tab
> You will Observe that the Connection type is-- Web Query
> You will also observe the Edit query does not have the query listed
> Click on Edit Query
>It gives an error occurred and does not allow us to edit the query
Till CRM 2013, CRM 2015 RTM after exporting dynamic worksheet we had an option of Database Query under Connection type and it allowed us to edit the query in order to make changes from Excel itself
Ask:
The function was easy to use and allowed us to edit queries quickly without logging into CRM so it should be introduced once again so that it makes our life easy