The Excel Copilot update arriving in Microsoft 365 addresses something that anyone who works with spreadsheets regularly will recognise immediately. Getting data into the format you actually want takes time. Your business may always present currency a particular way, use specific report headings, apply consistent naming conventions, or follow formatting rules that everyone is expected to know. Explaining these preferences to Copilot every time you open a spreadsheet defeats the purpose of having an AI assistant. Microsoft has now addressed this directly.

What the Excel Copilot Update Introduces

The update allows users to teach Copilot their formatting preferences and have those preferences remembered for future use. Rather than making the same adjustments session after session, you explain once how currency should be displayed, how reports should be structured, or how certain types of data should be formatted. Copilot retains that information and applies it automatically going forward.

This is a meaningful shift from how AI tools in Excel have worked until now. Previous Copilot capabilities in Excel focused on answering questions, generating formulas, summarising data, and explaining calculations. All of these are useful. However, they still required the user to provide context and preferences each time. The new update begins to feel less like using a tool and more like working with something that has learned how your business operates.

For team members who find themselves making the same formatting corrections every time they open a particular type of report, or who spend the opening minutes of any AI interaction re-establishing preferences that should not need re-explaining, this change removes a specific and repetitive friction point. If you have ever wished Excel could simply remember how you like things done, this update is the answer to that.

Workbook Rules That Travel With the File

The second element of the Excel Copilot update is particularly useful for teams that share spreadsheets across multiple users. Microsoft is introducing workbook rules that are embedded in the spreadsheet itself and travel with it when the file is shared.

The problem this addresses is familiar to any business that relies on shared spreadsheets for reporting or data management. One person creates a report in a specific format. A colleague opens the same file and produces their section differently. A third contributor applies their own conventions. The result is a document that should look consistent but does not, and someone spends time standardising it before it can be used.

With workbook rules embedded in the file, Copilot understands how that specific spreadsheet should be handled regardless of who opens it. The rules go with the file. A colleague who opens the spreadsheet for the first time does not need to be briefed on the formatting conventions, because Copilot already has them. This creates a form of built-in consistency that does not depend on everyone having the same training or the same habits.

For businesses in Haywards Heath and across Sussex that use shared spreadsheets for financial reporting, project tracking, or operational data, this is a practical improvement that reduces the inconsistency that tends to develop when multiple people contribute to the same documents over time.

Why This Matters for Business Productivity

The productivity benefit of the Excel Copilot update is most visible when you consider how much time is currently spent on formatting that is not the actual work. Preparing a report involves gathering the right data, running the right calculations, and presenting the information in a way that is clear and consistent with how your business communicates. The first two steps require expertise and judgement. The third is largely repetitive application of rules that everyone already knows.

When AI handles the formatting consistently and automatically, the person working on the spreadsheet can focus more of their attention on the analysis and the decisions the data supports. The report still gets reviewed and the figures still get checked, as they should. However, the time spent adjusting currency display, fixing heading formats, and standardising layouts is significantly reduced.

This connects to the broader value of teaching AI how a business works rather than treating it as a generic tool. Our article on the Microsoft Copilot memory feature covers how Copilot is becoming more personalised across Microsoft 365 applications, allowing the AI to build up a contextual understanding of individual preferences and business practices over time.

Human Oversight Remains Essential

The Excel Copilot update makes formatting faster and more consistent. It does not remove the need for human review of the underlying data and calculations. Spreadsheets containing financial figures, business reporting, or information that informs decisions should always be checked by someone with the expertise to assess whether the output is correct, not only whether it looks right.

AI-generated output that appears well-formatted and professionally presented can still contain errors in the data or the formulas behind it. Formatting consistency is a useful quality signal, but it is not a substitute for numerical accuracy. Whoever is responsible for a spreadsheet remains responsible for its content, regardless of how the formatting was applied.

Our article on AI fatigue and approving AI output without checking covers how the polished appearance of AI-generated content can reduce scrutiny in ways that allow errors to slip through. The Excel Copilot update improves the experience of using Copilot in Excel, but the discipline of genuine review remains as important as ever.

What This Means For Businesses

The Excel Copilot update is a practical step forward for businesses that use spreadsheets as a core part of how they manage and communicate information. Teaching Copilot your formatting preferences once and having them applied consistently removes a category of repetitive work that currently absorbs more time than it should. Workbook rules that travel with shared files address a specific and common source of inconsistency across teams.

For business owners and directors, the practical action is to explore these features within your existing Microsoft 365 Copilot subscription and to let team members who work extensively with Excel know they exist. A brief session to set up formatting preferences in the areas where your team does the most repetitive adjustment work will begin delivering benefit immediately.

Our cloud management page covers how businesses can ensure their Microsoft 365 environment is properly configured to take advantage of Copilot features across the full suite. Our managed IT services include Microsoft 365 configuration and Copilot support for businesses across Sussex and the South East.

Final Thoughts

The Excel Copilot update moves AI in Excel from a tool you operate to one that has learned how you work. Remembered formatting preferences and workbook rules that travel with shared files are not dramatic capabilities, but they address real and frequent friction points in how teams use spreadsheets day to day.

If Excel can spend less time asking how you would like something formatted and more time helping you get the actual work done, that is a change worth having. Explore the preference settings, set up the conventions your business uses most frequently, and let the consistency benefits follow from there.