Forum Discussion

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor
    Jul 20, 2026

    The short answer is yes, but with a very important distinction. Let me break it down clearly for you:

     1. Third-party DATA (Connecting to external servers): YES

    You can absolutely connect Excel Copilot to external data sources—like financial databases (FactSet, PitchBook), CRMs, or your own company servers. This is done via Microsoft Connectors:

    • Synced Connectors index external data into Microsoft Graph so Copilot can search across it.
    • Federated Connectors (using the Model Context Protocol) pull live data on demand, without storing it in your workbook.

    So if you want Copilot to analyze data from a third-party server, that is fully supported.

     2. Third-party AI MODELS (e.g., using Claude instead of Microsoft's engine): YES, but only from a pre-approved list

    As of mid-2026, the standard Excel Copilot pane includes a model picker (an "Auto" dropdown). If your IT admin has enabled it, you can choose between Microsoft's models and third-party options like Anthropic's Claude. This lets you switch AI engines for generating formulas, analyzing data, or fixing errors.

     3. The hard "NO" (what you cannot do):

    You cannot point Excel Copilot to your own private, self-hosted AI server (e.g., an open-source LLM running on your own infrastructure). The third-party model choice is limited strictly to Microsoft's integrated partners—you cannot manually configure a connection to an arbitrary custom model server.

     

    One important regional note: If you are in the EU, EFTA, or UK, Anthropic models are turned off by default. Your admin must manually opt-in to make them available.

     

    In a nutshell…You can bring your own data servers and choose between Microsoft's approved AI engines, but you cannot install your own custom AI engine directly into the Copilot pane. For anything beyond that, you would need to build a custom solution (e.g., using Copilot Studio or a script/add-in).

    This content was created with the support of multiple AI tools and should be independently verified before use.

    My answers are voluntary and without guarantee!

     

    Hope this will help you.