apply_formula · Excel MCP: Risk & Policy

WHAT IT DOES

What apply_formula does on Excel

AI agents use apply_formula to create or update resources in Excel — usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Excel environment.

WHY IT NEEDS A POLICY

Why apply_formula needs a policy

This tool writes a formula into a specific cell in an Excel file, modifying the workbook's content. This is a reversible write operation (the formula can be overwritten or deleted), not destructive. Misuse could corrupt calculations or data integrity but does not irreversibly delete data.

From the tool's definition Apply a formula to a cell

Attacks that exploit this kind of access

Recommended rule Ready

Verdict

apply_formula Rate-limited

apply_formula stays usable, but capped — an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "apply_formula": {
      "limits": [
        {
          "counter": "apply_formula_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL →

Instant setup, no code required.

PolicyLayer is an MCP gateway: every tool call is checked against your rule before it reaches Excel, so you can run agents against it safely.

FAQ

Questions about apply_formula

What does the apply_formula tool do? +

Apply a formula to a cell. It is categorised as a Write tool in the Excel MCP Server, which means it can create or modify data. Consider rate limits to prevent runaway writes.

How do I enforce a policy on apply_formula? +

Register the Excel MCP server in PolicyLayer and add a rule for apply_formula: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Excel. Nothing to install.

What risk level is apply_formula? +

apply_formula is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit apply_formula? +

Yes. Add a rate_limit block to the apply_formula rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block apply_formula completely? +

Set action: deny in the PolicyLayer policy for apply_formula. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides apply_formula? +

apply_formula is provided by the Excel MCP server (shmaxi/excel-mcp-server-node). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.