Excel AddIn Enhancement - when refreshing values, remove old values if dimension of table changes

Thinus99

Suppose that you have an Excel add in output with 10 rows and 10 columns of values. No suppose that the user ‘unticks’ or ‘unselected’ columns in the Anaplan addin and the updated extract produces output of 10 rows and 8 columns, previous values (2 non-updated columns) keeps their values.

It would be better if the old values are removed when the link is updated.