You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
So I have to manually delete the named ranges before recreating the data tables. I think this is due to line 142 in WhatIfAnalysis.gs looking for the index of a name in an array of NamedRange objects (not their names). This returns -1 so the ranges are not deleted.
The text was updated successfully, but these errors were encountered:
So I have to manually delete the named ranges before recreating the data tables. I think this is due to line 142 in WhatIfAnalysis.gs looking for the index of a name in an array of NamedRange objects (not their names). This returns -1 so the ranges are not deleted.
The text was updated successfully, but these errors were encountered: