Claude in Excel Financial Model: It Found and Fixed the #REF!

Claude in Excel, real demo: I gave the Claude add-in a broken financial model and five jobs, and it found and fixed the #REF! with one prompt. The fix Claude wrote: =SUM(B19:D19) Free 2026 Formula Pack (cheat sheet + all practice files): https://thepivotgrid.com/formula-pack... Claude now runs inside Excel as an official add-in from Anthropic. On a small 3-year forecast I did not build, it explains the model, changes an assumption without touching the formulas, traces a reference error to its cause, builds a scenario table with linked formulas, and adds conditional formatting and a drop-down. You also see the limits: it asks permission before every change, each answer takes 30 to 75 seconds, and Anthropic says to check its work. Needs a paid Claude plan (Pro, Max, Team or Enterprise); runs in Excel for the web, Windows and Mac. In this video: ► 0:00 Claude fixed a broken summary with one prompt ► 0:29 Open Claude in Excel and let it explain a model you did not build ► 1:15 Change an assumption, every formula intact ► 1:43 Find and fix the #REF! error at its source ► 2:24 Build a scenario table linked to the model ► 2:47 Red formatting and a drop-down in one prompt ► 3:15 The limits: permission, speed, plans and install Free practice file (the model with the broken summary): https://thepivotgrid.com/files/ThePiv... Next: the free ChatGPT add-in on a messy file:    • ChatGPT Now Works Inside Excel and Google ...   --- ABOUT THE PIVOT GRID Welcome to The Pivot Grid, your central hub for mastering Microsoft Excel and Google Sheets. This channel is built to bridge the gap, helping you navigate the unique strengths of both platforms with practical tutorials, comparisons, and automation tips. RESOURCES & LINKS Free 2026 Formula Pack, 3-page cheat sheet + practice files: https://thepivotgrid.com/formula-pack... Free practice files: https://thepivotgrid.com/#files --- LET'S CONNECT Got a question or a topic suggestion? Let me know in the comments below! Subscribe to the channel to level up your spreadsheet skills every week. #ClaudeAI #Excel #ExcelAI #ThePivotGrid