Remove ALL named ranges including invalid references?

I've tried every script I can find to remove invalid reference named ranges without any luck. I even tried removing all named ranges using the script below, yet the invalid references remain. Does such solution exist via script, or do I have to manually delete a 100 or so named ranges manually?

var namedRanges = SpreadsheetApp.getActive().getNamedRanges();  for (var i = 0; i < namedRanges.length; i++) {    namedRanges[i].remove();  }  

Developer Reference

https://stackoverflow.com/questions/66163613/remove-all-named-ranges-including-invalid-references February 12, 2021 at 06:02AM