How To Sync Field Changes In Excel Templates That Display Dynamic Data – Therapy in Code

Introduction

Have you ever created an Excel template for displaying dynamic data from a custom entity view? Then decide to do a bunch of custom work to that Excel template to satisfy your user base. Things like graphs, pivot tables, charts, KPIs, Power Query data references to 3rd party sources just to name a few. Then after all that hard work you upload that customized gem back into…