Copilot mistakes in Excel formulas

John Mol 0 Reputation points
2026-09-12T19:51:00.3166667+00:00

I don't understand why Copilot is not able to create a template of a set of basic financial statements in Excel without obvious mistakes in the formulas.

Microsoft Copilot | Other
0 comments No comments

1 answer

Sort by: Oldest
  1. Hendrix-V 18,925 Reputation points Microsoft External Staff Moderator
    2026-09-13T03:38:42.2533333+00:00

    Hi John Mol,

    While Copilot can help accelerate spreadsheet creation and formula generation, AI-generated content should be reviewed and validated before it is used for financial analysis or reporting. In some cases, Copilot may produce formulas that do not fully align with the intended accounting structure or business logic, requiring manual verification and adjustment.

    If the issue is reproducible, it may be helpful to:

    1. Save a copy of the workbook containing the incorrect formulas.
    2. Compare the generated formulas with the expected calculations to identify specific discrepancies.
    3. Submit feedback directly through Copilot in Excel, including examples of the formulas and the expected results.
    4. If the behavior is impacting your work, contact Microsoft Support and provide the workbook details along with steps to reproduce the issue.

    Please note that this is a user-to-user support forum. Moderators, contributors including external Microsoft employees cannot directly intervene in Microsoft product features or access back-end systems. Our role is limited to providing technical guidance on reported issues, requests, or ideas.

    Feedback such as yours is valuable because it helps identify scenarios where Copilot responses may benefit from further refinement, particularly for structured financial models and spreadsheet calculations.

    Let me know if you need further assistance, feel free to ask me by clicking "Add Comment" or "Add Answer" if you cannot add comment so your response will be visible. Thanks for your effort.


    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Was this answer helpful?

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.