# Extend an existing financial model with Claude in Excel without breaking it

> Have Claude explain how the tabs connect and annotate complex formulas first, then extend the model following the original patterns while you check its assumptions.

- **Category:** [Excel](https://stepgleam.com/categories/excel)
- **Difficulty:** Advanced
- **Time:** ~60 minutes
- **Tools:** Claude in Excel, Excel (Microsoft 365)
- **Reliability score:** 72/100
- **Steps:** 5
- **Last updated:** 2026-10-26
- **Published:** 2026-10-26

## Tools used

- [Claude in Excel](https://claude.com) — Reads formulas, adds comments and extends the model
- [Excel (Microsoft 365)](https://support.microsoft.com/en-us/excel) — Holds the model

## What you'll get

An extended model with commented new formulas, where you have checked the assumptions Claude relied on.

## Who this is for

FP&A and finance people who maintain multi-tab models.

## Before you start

Finance users on r/FPandA say Claude in Excel is good at debugging formulas and building from scratch, but can break existing models if the prompt is slightly off. Anthropic's own example for inherited spreadsheets starts with understanding before extending. This guide follows that order.

## Steps

### Step 1: Ask Claude to explain how the tabs connect first

**Tool:** Claude in Excel

Before any change, ask for the structure: how the tabs connect, what the key formulas do, and what isn't documented. Anthropic's example asks Claude to read the existing Legend tab and cell comments first.

**Why this works:** Understanding first keeps the extension consistent with the original logic.

**Prompt:**

```
Read the Legend tab and the cell comments, then explain how the four tabs connect, what the seasonality and CAC payback formulas do, and anything important that isn't documented. Don't change anything yet.
```

[Open step 1](https://stepgleam.com/guides/extend-an-existing-model-with-claude-in-excel#step-1)

### Step 2: Have it annotate the complex formulas

**Tool:** Claude in Excel

Ask Claude to add cell comments explaining complex formulas and flagging logic that wasn't clear. Anthropic describes ending up with *"both an explanation and a marked-up file you can reference later."*

[Open step 2](https://stepgleam.com/guides/extend-an-existing-model-with-claude-in-excel#step-2)

### Step 3: Check its reading of the assumptions yourself

**Tool:** Excel (Microsoft 365)

An FP&A user's warning: *"if your prompt is even a little off, it can misunderstand the assumptions. I think you still need to really understand the model logic yourself."* Compare Claude's explanation with the formulas before you go on.

**Why this works:** Existing models are where it breaks things.

[Open step 3](https://stepgleam.com/guides/extend-an-existing-model-with-claude-in-excel#step-3)

### Step 4: Ask for the extension with very specific instructions

**Tool:** Claude in Excel

Ask it to extend the model following the original patterns and to comment any new formulas. Users stress specificity: *"You have to be very specific"*, and another user who finds it works with their existing model still says *"I have to be very specific with what I am asking it to do."*

**Prompt:**

```
Extend the model through Q3 2026 using the same formula patterns as the existing quarters. Comment every new formula. List every cell you changed.
```

[Open step 4](https://stepgleam.com/guides/extend-an-existing-model-with-claude-in-excel#step-4)

### Step 5: Iterate, then spot-check the new periods

**Tool:** Claude in Excel

Review the list of changed cells, check a few new periods by hand, and ask for fixes. One user's approach: *"ask it to make recommendations and then iterate. Iterate. Iterate."*

[Open step 5](https://stepgleam.com/guides/extend-an-existing-model-with-claude-in-excel#step-5)

## Pro tips

- Work on a copy of the model.
- Ask Claude to list every cell it changed so you can review them.

## Common mistakes

- Asking for the extension before Claude has explained the model.
- Handing off an existing model blindly.

## FAQ

### Is it good for charts?

One FP&A user found it *"surprisingly good at making charts."*

### Can it handle circular references?

An r/ClaudeAI user who builds models with circular references says it follows them, but finance users still check the logic themselves.

---

Canonical guide: https://stepgleam.com/guides/extend-an-existing-model-with-claude-in-excel
Read this guide as Markdown: https://stepgleam.com/guides/extend-an-existing-model-with-claude-in-excel.md