Defined names
xlide_manage_nameManage defined names in Excel workbooks: list, add, or remove named ranges and formulas. Use to safely update references that formulas and VBA code depend on.
Instructions
Lists, adds or removes a workbook's defined names. A defined name is what lets a formula say TaxRate rather than Config!$B$7, and VBA reads them too, so renaming or removing one can break code as well as formulas. action='list' changes nothing. refers_to is a formula, so it needs its sheet and its dollar signs: Data!$A$1:$A$50.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | For add and remove: the defined name. | |
| scope | No | A sheet name to scope it to that sheet. Empty means the workbook. | |
| action | No | list, add or remove. | list |
| file_path | Yes | Absolute path to the Excel file. | |
| refers_to | No | For add: what it points at, such as Data!$A$1:$A$50. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||