How to use AI in Excel without the cloud

Native steps checked against Microsoft Support on 16 November 2026 · updated 16 November 2026

To use AI in Excel without the cloud you need an add-in talking to a model on your own machine: Excel has no built-in offline assistant, and Copilot in Excel is a Microsoft 365 service whose prompts and responses are governed by Microsoft's enterprise data protection terms.

The native Excel method

  1. Open the Copilot pane in Excel for Microsoft 365 to see what the licensed service offers.
  2. Read Microsoft's account of how prompts and responses are handled, including logging and retention.
  3. Check whether your subscription includes Copilot before relying on it for a confidential workbook.
  4. If the data cannot leave the machine, plan for a local model behind an add-in instead of the Copilot pane.

What Excel offers natively

Copilot in Excel is Microsoft’s assistant inside the application. It is documented for Excel for Microsoft 365 and works through a chat pane that suggests formulas, analyses data and builds charts and PivotTables (Microsoft Support).

It is a service, not a local engine. Microsoft’s enterprise data protection documentation describes prompts and responses being processed within the Microsoft 365 service boundary and logged, with retention and audit under tenant policies (Microsoft Learn).

Why this guide is a draft

The stage that produced this page requires every native Excel step to be checked against Microsoft’s own documentation. The steps above are checked. What cannot be verified from a product page is a negative: that no local, offline AI feature exists in Excel today. Microsoft documents Copilot as a cloud service, but a support page cannot prove the absence of anything else, so this page stays a draft until that is confirmed another way.

Where a local model fits

If the workbook cannot leave the machine, the assistant has to run against a model on that machine, through an add-in rather than through the Copilot pane. That is the design CalcoraSuite is aiming at: off by default, local endpoint by default, and a remote endpoint only if you configure one — see the AI assistant page for status and the security page for the data stance.

The CalcoraSuite way

Planned, not released. The ai assistant page carries the current status of each step (planned).

  1. Install the add-in and leave the assistant off; nothing runs until it is enabled.
  2. Confirm the endpoint in settings points at the local model.
  3. Ask a question about the open workbook and check the answer against the cells it cites.

Sources

Every native step above was checked against these Microsoft pages on 16 November 2026.

Get the add-in before release

Early access testers get each add-in first, with a short list of what to try.