By Jetformat
Named ranges make formulas readable but can point somewhere unexpected after workbook edits. List names before adding or removing one.
Steps
- Start with a local XLSX. Replace the sample paths and identifiers with your own.
- Run the command below. Read the returned data before choosing a follow-up edit.
- Check the result as described below before using it in another job.
jetformat excel names finance.xlsx
Check the result
Compare the references against current sheet names and ranges, especially after renaming or deleting sheets.
Notes and limits
This is a free utility or read operation. It does not need a paid conversion to inspect the result.
Run jetformat excel names --help to compare options with your installed version.
See the excel command reference for the surrounding workflow.