Named Range and Table Reference Audit
Check that references are stable and understandable.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
Audit how my workbook uses named ranges, tables, and cell references. Spreadsheet app: [SPREADSHEET_APP]. Description of the workbook: [WORKBOOK_DESCRIPTION]. List of named ranges with their references, or a description of tables and key formulas: [PASTE_NAMES_AND_FORMULAS]. Check each item, answer Yes, No, or Cannot tell, and give the fix: [ ] Names follow one convention and say what they contain [ ] No names pointing to deleted or wrong ranges (#REF!) or to other workbooks [ ] No duplicate or conflicting names at workbook and sheet level [ ] Ranges for charts, validation lists, and summaries use tables or dynamic ranges that grow with data [ ] Formulas do not point to a fixed range that omits new rows [ ] Structured table references used where available [ ] Input cells are named, so assumptions are easy to find [ ] Whole-column references are used carefully for performance [ ] Ranges do not include header or total rows by accident [ ] Hidden names are reviewed [ ] A name manager listing is documented on a sheet Provide a table of problem names (name, current reference, issue, fix), a naming convention of five rules with examples, and a safe procedure for renaming without breaking formulas. Mention backup before changes.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.