Skip to main content
Glama
WilliamSmithEdward

xlide-excel-word-powerpoint-access-office-vba-mcp

Defined names

xlide_manage_name
DestructiveIdempotent

Manage 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

TableJSON Schema
NameRequiredDescriptionDefault
nameNoFor add and remove: the defined name.
scopeNoA sheet name to scope it to that sheet. Empty means the workbook.
actionNolist, add or remove.list
file_pathYesAbsolute path to the Excel file.
refers_toNoFor add: what it points at, such as Data!$A$1:$A$50.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.1.0

TDQS

A4.5/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Annotations already declare destructiveHint=true and readOnlyHint=false; the description adds valuable nuance by explaining that mutating names can break VBA code and formulas, and by explicitly flagging that the list action is side-effect-free. No contradiction with annotations.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

Three tightly written sentences: the first states function, the second provides necessary risk context, and the third gives actionable parameter guidance. Every sentence earns its place and key material is front-loaded.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

Given that the input schema documents all parameters and an output schema exists, the description covers everything an agent needs: what the tool does, when list is safe, why mutations are risky, and how to construct a valid refers_to argument. No critical gaps remain.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3. The description adds practical meaning beyond the schema by explaining that refers_to must contain sheet names and dollar signs (Data!$A$1:$A$50) and by clarifying the behavioral difference of the action='list' value.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

Clearly states the resource (workbook defined names) and the exact actions (lists, adds, removes). The TaxRate example makes the concept immediately recognizable and distinguishes this tool from sibling sheet/cell/module tools.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides clear context on safe usage ('action='list' changes nothing') and on how to format refers_to, which is essential for calling the tool correctly. It does not explicitly name alternatives or exclusions, but no competing sibling tool exists for this specific resource.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.