Update Excel file connections to CRM

In scope of our CRM Dynamics 2013 On premise to CRM Online migration, we had users who created dynamic Excel workbook based on CRM views. When switching environment, URL changed (to become xxxx.crm4.dynamics.com) which prevented existing workbooks to work. We found out no other way than edit »