Live Comps Without Leaving the Cell Using the New COPILOT Web Function
The comparable companies tab has always been the slowest, least satisfying part of a valuation. You leave the model, hit a data provider or a filings page, copy a multiple, paste it back, and repeat until your hands ache — and the moment you finish, the numbers are already stale. Microsoft's [May update to the =COPILOT function](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-may-2026/4502700) takes a real run at that grind: the function can now search the web directly and pull live information into a cell through a formula, so current benchmarks and company details arrive without you ever leaving the workbook.
That turns a comps table from a manual chore into something closer to a living query. Instead of hard-pasting a figure that decays on contact, you can write a formula that asks for the metric you want and returns it inline, refreshing when you recalc. As [Windows Report noted](https://windowsreport.com/microsoft-added-these-new-features-to-excel-in-may-2026/), the capability is aimed squarely at fetching current company information, external benchmarks and web-based details straight into the grid.
The obvious use is a self-refreshing comps sheet. Lay out your peer set down the rows, put the metrics you care about across the top, and let the web-enabled function populate the cells. Pair it with the Python-in-Copilot support [that landed in April](https://techcommunity.microsoft.com/blog/excelblog/whats-new-in-excel-april-2026/4502696) and you can clean, reshape and chart the pulled data in the same place, without a separate notebook or an export dance.
Two cautions, because this is exactly where discipline earns its keep. First, the feature is rolling out through Insider and Frontier channels, so check your build before you promise a live model to a client. Second, a formula that fetches a number is only as trustworthy as the source behind it, and a valuation that anchors on an unverified web figure is a liability dressed up as automation. Log where each pulled value came from, and keep a human on anything that feeds a price.
At Cell Fusion Solutions Inc we wire these live functions into a verification layer, so every fetched benchmark carries a source and a timestamp your reviewer can actually defend. Used carefully, the web-enabled =COPILOT function does not just save the copy-paste — it means your comps are current the moment someone opens the file, which is the whole point of a comp in the first place.
