Latest / Ctrl AI Profit / Ep. 280 | Claude Can Find the Broken Formula in Your Excel Workbook
Transcript
- 0:20SPEAKER_01: Somebody built your pricing spreadsheet years ago.
- 0:24SPEAKER_01: You changed one number, and now the totals just say ref error.
- 0:28SPEAKER_01: Nobody in the building knows why.
- 0:30SPEAKER_00: Claude can now work inside Excel, find the cell that broke, tell you why, and fix it only when you say so.
- 0:38SPEAKER_00: Every answer points to the exact cells, so you can check it.
- 0:41SPEAKER_01: So today, who qualifies?
- 0:44SPEAKER_01: The install, exactly what to type, how to check its work, and what it can't touch.
- 0:49SPEAKER_00: The one new term is Claude for Excel.
- 0:52SPEAKER_00: Plain English, please.
- 0:54SPEAKER_00: It's an add-in.
- 0:56SPEAKER_00: That's a small app from Anthropic, the company behind Claude, that opens as a panel on the right side of your workbook.
- 1:02SPEAKER_00: It reads every tab and every formula in the file you have open.
- 1:07SPEAKER_01: Quick one, because Anthropic also announced something called Claude Sheets this week.
- 1:13SPEAKER_01: Same thing?
- 1:14SPEAKER_00: No.
- 1:15SPEAKER_00: Claude Sheets is a new, simple spreadsheet inside the Claude app in beta.
- 1:20SPEAKER_00: Anthropic's own post says for full Excel, use Claude for Excel.
- 1:25SPEAKER_00: That's today on the file you already have.
- 1:28SPEAKER_00: Who can use it?
- 1:29SPEAKER_00: I'm guessing there's fine print.
- 1:31SPEAKER_00: You need a paid Claude plan, Pro, Macs, Team, or Enterprise.
- 1:37SPEAKER_00: Then Excel on the web, Excel on Windows with a Microsoft 365 subscription, or Excel on a Mac version 16.46 or later.
- 1:46SPEAKER_00: And who's out?
- 1:48SPEAKER_00: Excel 2016 or 2019 that you bought once, Excel on iPad, and Excel on Android.
- 1:56SPEAKER_00: If your Excel comes with Microsoft 365 and stays updated, you're probably fine.
- 2:02SPEAKER_01: Step one, go to Microsoft App Source, that's Microsoft's App Store for Office, and find the listing called Claude for Microsoft 365 by Claude by Antopic for Office.
- 2:14SPEAKER_00: That name trips people up.
- 2:16SPEAKER_00: A Reddit thread asked if the old Excel add-in was retired.
- 2:20SPEAKER_00: The current listing is Claude for Microsoft 365, covering Excel, Word, and PowerPoint.
- 2:27SPEAKER_00: Select Get It Now.
- 2:29SPEAKER_01: Step 2.
- 2:30SPEAKER_01: Open Excel.
- 2:32SPEAKER_01: On Windows, go to the Home tab, then add-ins.
- 2:34SPEAKER_01: On a Mac, it's the Tools menu, then Add-ins.
- 2:37SPEAKER_01: Pick Claude and sign in with your Claude account.
- 2:40SPEAKER_00: Anthropics tutorial also gives a keyboard shortcut to open the panel.
- 2:45SPEAKER_00: Control Alt C on Windows.
- 2:47SPEAKER_00: Control Option C on a Mac.
- 2:49SPEAKER_00: Before I type a single thing?
- 2:52SPEAKER_00: Save a copy of the workbook.
- 2:54SPEAKER_00: Anthropics best practices say start from a trusted copy before big edits.
- 2:58SPEAKER_00: If it goes sideways, the original is untouched.
- 3:01SPEAKER_00: Okay, the panel's open.
- 3:03SPEAKER_00: First ask.
- 3:04SPEAKER_00: If you didn't build the file, start here.
- 3:07SPEAKER_00: Type, quote, walk me through this workbook.
- 3:10SPEAKER_00: What's on each tab and how do they connect?
- 3:13SPEAKER_00: End quote.
- 3:14SPEAKER_00: That's Enthropic's own prompt.
- 3:16SPEAKER_00: Claude reads every tab, explains how the totals roll up, and in their demo it flagged ref errors nobody asked about.
- 3:23SPEAKER_00: Plus every cell they hit.
- 3:25SPEAKER_01: People on X say the same about inherited files.
- 3:28SPEAKER_01: Explain first, touch second.
- 3:31SPEAKER_01: And what is a ref error for somebody who's never had to care?
- 3:35SPEAKER_00: Microsoft says it shows up when a formula points at a cell that isn't valid anymore, most often because the cells it used got deleted or pasted over.
- 3:43SPEAKER_00: Somebody deletes a column and three tabs break.
- 3:46SPEAKER_01: So what do I type to hunt it down?
- 3:49SPEAKER_00: Anthropics example is quote, find the source of the ref error in the summary tab.
- 3:56SPEAKER_00: End quote.
- 3:56SPEAKER_00: Or point at one cell.
- 3:58SPEAKER_00: Quote, there's a ref error in cell E15 on the headcount tab.
- 4:03SPEAKER_00: What's causing it and can you fix it?
- 4:06SPEAKER_00: End quote.
- 4:07SPEAKER_00: Swap in your own tab and cell.
- 4:09SPEAKER_00: And what comes back?
- 4:12SPEAKER_00: In the tutorial, Claude traces it to the deleted reference, explains the cause, and shows you options for the fix.
- 4:18SPEAKER_00: Then you pick.
- 4:19SPEAKER_00: You stay in control of what changes.
- 4:22SPEAKER_01: Now the divide by zero one.
- 4:24SPEAKER_01: I see that on every new month.
- 4:27SPEAKER_00: Type quote trace y cell H15 is returning the divide by zero error.
- 4:34SPEAKER_00: End quote.
- 4:35SPEAKER_00: Microsoft says that error means the formula is dividing by a zero or a blank cell, like a month, with no sales entered yet.
- 4:43SPEAKER_00: How do I know Claude is right and not just confident?
- 4:47SPEAKER_00: Every answer comes with cell level citations, little links to the cells it means.
- 4:52SPEAKER_00: Click one, and Excel jumps to that cell.
- 4:55SPEAKER_00: Look at it yourself.
- 4:56SPEAKER_01: Here's the one I'd actually use.
- 4:58SPEAKER_01: A number on the summary that I just don't believe.
- 5:02SPEAKER_00: Type, quote, walk me through how the revenue number in cell C42 is calculated.
- 5:08SPEAKER_00: End quote, use your own cell, like the job total on a quote sheet.
- 5:13SPEAKER_00: You get the chain of cells behind that number, with citations.
- 5:17SPEAKER_01: Okay, it found the problem, and now it wants to fix it.
- 5:20SPEAKER_00: Anthropic says when Claude proposes a risky change, you're asked to confirm before it runs, and it warns you before it overwrites existing data.
- 5:28SPEAKER_00: Read what it's about to change, then say yes or no.
- 5:32SPEAKER_00: Anything I should say no to?
- 5:35SPEAKER_00: If the fix is just wrapping the formula in something called if error, slow down.
- 5:40SPEAKER_00: Microsoft warns that hides every error in that formula, not just this one.
- 5:45SPEAKER_00: Make sure the formula actually works first.
- 5:48SPEAKER_01: And if I said yes and I regret it?
- 5:50SPEAKER_00: Control Z on Windows, Command Z on a Mac, Anthropics tutorial says undo reverses most actions.
- 5:58SPEAKER_00: Most, not all.
- 6:00SPEAKER_00: That's why you save the copy.
- 6:02SPEAKER_01: One complaint on X this week.
- 6:04SPEAKER_01: Claude writes formulas way more complicated than they need to be.
- 6:09SPEAKER_00: Fair warning.
- 6:10SPEAKER_00: So in desktop Excel, check any formula it writes with Excel's own tool, Evaluate Formula.
- 6:16SPEAKER_00: Click the cell, go to the Formulas tab, and in the formula auditing group, select Evaluate Formula.
- 6:22SPEAKER_00: Each time you select Evaluate, Excel works out the next piece, step by step.
- 6:28SPEAKER_01: I saw a tip on X to check the AI's work with Evaluate Formula or the F9 key.
- 6:35SPEAKER_01: Is F9 real?
- 6:36SPEAKER_00: It's real, and it's on Microsoft's support page.
- 6:39SPEAKER_00: Click the cell and in the formula bar highlight one piece of the formula and press F9.
- 6:45SPEAKER_00: Excel shows what that piece equals.
- 6:48SPEAKER_00: Microsoft warns if you press enter, that piece gets replaced with the number.
- 6:52SPEAKER_00: So press escape to back out.
- 6:55SPEAKER_01: Escape, not enter.
- 6:57SPEAKER_01: Got it.
- 6:58SPEAKER_01: Last ask, flexing a number.
- 7:01SPEAKER_00: Anthropic's example is change the discount rate to 8% and update dependent calculations.
- 7:07SPEAKER_00: Our shop version would be quote, raise the labor rate on the assumptions tab by 5% and update dependent calculations.
- 7:14SPEAKER_00: End quote.
- 7:15SPEAKER_00: Claude changes the input and keeps formulas connected so everything downstream recalculates.
- 7:22SPEAKER_00: What won't it do?
- 7:24SPEAKER_00: Anthropic lists two things it doesn't support data tables and macros or VBA.
- 7:31SPEAKER_00: If your workbook runs on macros, that part stays a job for a person.
- 7:36SPEAKER_01: Now the scary part.
- 7:37SPEAKER_01: Can a file trick it?
- 7:39SPEAKER_00: Yes.
- 7:40SPEAKER_00: Anthropic calls it prompt injection, a downloaded template or vendor file hiding instructions.
- 7:47SPEAKER_00: Someone on X pointed to a case with hidden text in a spreadsheet.
- 7:50SPEAKER_00: Anthropic's rule.
- 7:52SPEAKER_00: Trusted spreadsheets only and read every confirmation.
- 7:56SPEAKER_01: Where does my data go when it reads the file?
- 7:59SPEAKER_00: What Claude reads from your workbook is sent to Anthropic.
- 8:02SPEAKER_00: They say it's deleted within 30 days, except as their data policy describes, and it counts against your normal Claude usage limits.
- 8:10SPEAKER_00: And Anthropic says don't trust it on audit critical numbers or anything going to a client without a human review.
- 8:17SPEAKER_01: Okay, one thing to try this week: make a copy of the spreadsheet nobody wants to touch, open Claude, type walk me through this workbook, then ask it to find the source of any error it flags.
- 8:28SPEAKER_01: Click the citations before you let it change a thing.
- 8:32SPEAKER_00: And check one formula yourself with evaluate formula.
- 8:35SPEAKER_00: Thanks for listening to Control AI Profit.
- 8:38SPEAKER_00: If this helped, pass it to whoever owns your shop spreadsheets.
- 8:41SPEAKER_00: We'll see you next time.