google-sheets-what-if-analysis icon indicating copy to clipboard operation
google-sheets-what-if-analysis copied to clipboard

Published 20 hours ago • verified publisher icon sajacy

Delete All Data Tables doesn't delete named ranges

Open jackru opened this issue 4 years ago • 0 comments

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.

jackru avatar Jun 05 '20 11:06 jackru