Currently, when exporting a file from the Spreadsheet that contains named ranges, which refer to invalid or missing references (e.g., "#REF!"), the exported file is corrupted when attempting to open it in Excel:

Is it possible to remove any invalid named ranges before exporting the file to avoid such a warning when opening the file in Excel? Alternatively, rewrite the invalid named ranges in the exported file, so they are ignored by Excel when opening the exported file.

By default, when opening a file with invalid named ranges in Excel, there is no automatic warning to the user.