CRE AI SOLUTIONS
Every BOV Deck Is Stale by Thursday. Claude in Excel Fixes That.
The model changed Tuesday. The deck still says Monday. Every brokerage and investment sales team knows the gap: the Excel model is alive, the BOV or OM deck is a snapshot, and someone spends Thursday night retyping numbers into slides that were current when the week started. Members keep asking whether AI can close that gap, and the tooling finally has a real answer, with one catch nobody mentions in the demos.
Direct answer
Direct answer to AI update BOV deck from Excel model
The retype gap is closing from two directions: Claude now operates inside Excel, reading and modifying workbooks while preserving formula dependencies, and connects to Microsoft 365 to carry context from spreadsheet to slides. But a sync is only as good as its source of truth. The teams that get this working name the model as the single source, structure it so a tool can read it, generate the deck from the model rather than editing slides by hand, and keep a person approving every version that leaves the building. The catch: a deck generated from a messy model automates the mess.

The gap, and why retyping persisted this long
The workflow every investment sales and debt team runs has two artifacts with different metabolisms. The Excel model changes daily: a comp lands, the lender revises proceeds, the seller trades a concession. The deck changes when someone has an hour, because updating it means finding every figure the model moved, retyping it in three places, and hoping the sensitivity table on slide 14 was not missed. The result is a permanent, low-grade version conflict between the two documents a client sees, and everyone in the industry has watched a committee catch a slide that disagrees with the model behind it. The reason this survived a decade of automation talk is that linking Excel to PowerPoint natively has always been brittle, and the deck is not really a projection of the model: it is a designed document that quotes the model in a hundred places.
What changed is that language-model tooling now operates inside the documents rather than beside them. Anthropic announced Claude for Excel on October 27, 2025 as part of its financial services expansion: an add-in through which Claude can, in the company’s words, read, analyze, modify, and create Excel workbooks, modify a spreadsheet while preserving its structure and formula dependencies, debug cell formulas, and populate templates with new data and assumptions. The same announcement describes Microsoft 365 integration that creates and edits Excel spreadsheets and PowerPoint slides and searches files, emails, and Teams conversations for context. At announcement the Excel add-in was in beta as a research preview for Max, Enterprise, and Teams users, initially capped at a thousand users, so current availability is a thing to check against Anthropic’s own pages rather than assume. Those capability descriptions are Anthropic’s claims; PSV’s read of what they mean for a CRE desk follows.
Why a CRE operator should care
Because the retype gap is not a formatting nuisance, it is an error surface in the documents clients price off. A BOV whose slide quotes last week’s NOI is a credibility problem when the client has the current number. And the hours are real: a team producing weekly pitch materials burns an analyst-evening per deck per revision cycle on transcription that produces nothing. The desks that close the gap get something better than saved hours, they get the ability to say yes to the Tuesday-night “can you rerun it at the new proceeds” request without a Wednesday-morning deck scramble, because the deck regenerates from the model instead of being hand-reconciled to it.
The catch the demos skip: generation from the model only helps if the model deserves to be the source of truth. A workbook with hardcoded overrides buried in formula cells, three tabs named Final, and inputs nobody can find will produce a deck that faithfully reproduces the confusion at presentation quality, which is worse than the retype gap because it looks finished. This is the same lesson as every other chain PSV builds: the automation amplifies the discipline that exists, in either direction. The prerequisite work, one canonical model file, inputs separated from calculations, assumptions on a labeled tab with owners, is exactly the discipline a good analyst wanted anyway. The tooling just made it pay twice.
The workflow PSV would run
Name the model as the single source of truth and demote the deck to a generated artifact. The inputs are the workbook, structured so a tool can navigate it, and a deck template whose every model-quoting field is identified. The workflow: when the model changes, the tool re-extracts the quoted figures, regenerates the deck from the template, and produces a change log, which figures moved, from what to what, on which slides. The reviewer is the deal lead, and the review is the change log first, the deck second, because the log is where a wrong number announces itself. The approval gate is unchanged from every PSV workflow: no version reaches a client, a committee, or a lender until a named person has signed the regenerated deck, and the change log is filed with it.
Sequence the adoption the boring way. Start with extraction only: the tool reads the model and produces the figure inventory, and the team confirms it found everything the deck quotes, including the sensitivity table and the footnotes. Then template the deck. Then let it regenerate drafts. A team that starts at full generation on a live mandate is testing in production on a client deliverable. And on availability: whether the firm reaches this through Claude for Excel, through Microsoft’s own tooling, or through a custom build against the model file directly is a procurement and licensing question that changes quarterly, so design the workflow around the pattern, source of truth, template, change log, human gate, and let the tool slot be replaceable. That last property matters more than any vendor’s current feature list.
What stays human, and the honest cautions
The operator read
Finish with the judgment call.
The reported facts are above. Enter your email for PSV's operator conclusion and a year of access to every newsroom brief.
Free. No card. Privacy policy. Unsubscribe anytime.
by PSVLiveBuild the workflow behind this analysis. Train with the operators doing it.
Real deal files, live builds, and production-ready CRE AI workflows inside the CRE AI Institute.
Clear answers
Common questions about AI update BOV deck from Excel model
Can AI keep a pitch deck in sync with an Excel model?
The tooling now exists. Anthropic announced Claude for Excel on October 27, 2025 as part of its financial services expansion: an add-in through which Claude can read, analyze, modify, and create Excel workbooks, modify spreadsheets while preserving structure and formula dependencies, and populate templates with new data and assumptions, per Anthropic. The same announcement describes Microsoft 365 integration that creates and edits Excel spreadsheets and PowerPoint slides. At announcement the add-in was a beta research preview for Max, Enterprise, and Teams users, so check current availability. The working pattern is generation, not editing: the deck regenerates from the model through a template, with a change log showing which figures moved and a named person approving every version that leaves the building.
Why do BOV decks and Excel models drift out of sync?
Because the two artifacts have different metabolisms and are reconciled by hand. The model changes daily as comps land, lenders revise proceeds, and terms trade; the deck changes when someone has an hour, because updating it means finding every figure the model moved, retyping it across slides, and hoping the sensitivity table was not missed. The result is a permanent low-grade version conflict in documents clients price off, plus an analyst-evening of transcription per revision cycle. The fix is architectural: name the model the single source of truth, identify every model-quoting field in the deck template, and regenerate rather than reconcile.
What should a team check before automating deck generation from a model?
Three things. First, whether the model deserves to be the source of truth: a workbook with hardcoded overrides, three tabs named Final, and unfindable inputs will produce a deck that reproduces the confusion at presentation quality. Inputs separated from calculations and assumptions on a labeled tab come first. Second, test vendor formula-preservation claims on a copy of the firm's ugliest real model before any live mandate touches the workflow. Third, licensing posture: models and decks contain client-confidential terms, so the tool reading them runs under the firm's commercial AI terms, not a personal account, and every regenerated version passes a named reviewer with the change log filed alongside.
Primary sources and operating references
These references support the control, research, and operating standards used in this guide. PSV’s workflow recommendations are original analysis.
Topics
Related PSV analysis
UNDERWRITING
One Claude Prompt, Full Underwriting: What Has to Be True First
Can Claude or ChatGPT run a full underwriting workflow, intake to IC draft, from a single prompt? It is the single most common question in PSV’s prospect calls and Institute office hours, usually asked by a team that has seen each step work in isolation and wants the button that runs them all. The honest answer is yes, the chaining is the easy part, and the reasons it fails have nothing to do with the prompt.
CRE AI ADOPTION
Why Claude and Copilot Pilots Flop in CRE. It’s Never the Model.
How should a CRE firm structure SharePoint or Drive so Claude, Copilot, or any AI tool can actually use it? Multiple operating teams have put the same question to PSV in almost the same words, usually after a pilot underperformed and the tool took the blame. The uncomfortable finding is that the AI was fine and the files were the problem: five versions of the rent roll, three naming conventions, and the real number in someone’s inbox.
OPERATING STANDARD
Is Claude Safe for CRE Data? Depends Which Claude You Bought.
Where does the data go? Every CRE firm evaluating Claude asks it, and for regulated managers it is the question that decides the purchase. The answer depends entirely on which Claude: the consumer plans and the commercial products run under different terms, with different training defaults and different retention. Here is the record as Anthropic publishes it, organized the way a compliance review actually proceeds.
Related guides
Cornerstone PSV guides on the workflows in this article.
Claude vs ChatGPT for CRE
An operator's comparison of Claude and ChatGPT for commercial real estate underwriting, and why the grounded setup matters more than the model brand.
Read the guideClaude for Real Estate Underwriting
The grounded underwriting workflow: real deal documents in, your rules applied, a source citation behind every number, a person signs off.
Read the guideWhat is CRE AI?
The definitional guide to commercial real estate AI: the core workflows, how it differs from a chatbot, and how to learn it.
Read the guide
by PSVLiveYou read the operator view. Now learn to run the workflow.
The AI MBA for commercial real estate: the workflows these briefs describe, taught end to end on real deal files, with live builds and a community of CRE operators.





