Consider a macro-free approach to the Excel-design

Excel does support Power Query, which is a capability that can be used to use for example an external json file as a datasource. Power Query can pull in the json, massage the data and make it available in certain tables. This would avoid having to deal with macro's. The user action is then a simple push on the "refresh" button. Happy to try this out when I get some bandwidth.

Review the existing Excel design and compare its current macro-based workflow with the Power Query approach described in the issue. Determine whether an external JSON source, data transformation, table output, and manual refresh can be specified as a concrete project change; done should include an agreed design and scope.

Written by the indexing model from the issue text.