How to Assign Copilot Agents to Word Excel and PowerPoint
🔍 WiseChecker

How to Assign Copilot Agents to Word Excel and PowerPoint

You want to make Copilot agents available inside Word, Excel, and PowerPoint so your team can use them directly from the Copilot pane. Agents are custom AI assistants that answer questions, generate content, and automate tasks based on data sources you define. This article explains how to assign Copilot agents to these Microsoft 365 desktop apps using the Microsoft 365 admin center, the Copilot Studio app, and the Copilot pane itself. By the end, you will know the exact steps to configure agent availability per app and per user group.

Key Takeaways: Assigning Agents to Office Apps

  • Microsoft 365 admin center > Copilot > Agents: Central location to publish and assign agents to all users or specific security groups.
  • Copilot Studio > Publish > Channels: Enables an agent in Word, Excel, and PowerPoint by selecting the Microsoft 365 channel.
  • Copilot pane > Agents button: Users select an assigned agent from the agent picker to activate it in the current document or worksheet.

ADVERTISEMENT

What Copilot Agents Are and How They Work in Office Apps

A Copilot agent is a custom AI assistant you build in Copilot Studio. It uses your own data sources, such as SharePoint sites, files, or databases, to answer questions and perform tasks. When you assign an agent to Word, Excel, or PowerPoint, users can open the Copilot pane and switch to that agent instead of the default Copilot chat. The agent then responds based only on the data you configured, not general web content.

Prerequisites for assigning agents include a Microsoft 365 Copilot license for each user, a Copilot Studio license for the agent builder, and the Copilot feature enabled in the Microsoft 365 admin center. The agents you assign appear in the Copilot pane of the desktop apps, the web versions, and the mobile apps. You can assign one agent to multiple apps or restrict an agent to a specific app. The assignment is managed through three separate interfaces: the admin center for global publishing, Copilot Studio for channel configuration, and the Copilot pane for user activation.

Steps to Assign Copilot Agents via the Microsoft 365 Admin Center

The admin center is the primary location to publish agents to all users or selected groups. Follow these steps to make an agent available in Word, Excel, and PowerPoint.

  1. Open the Microsoft 365 admin center
    Sign in with a Global Admin or Copilot Admin account. Go to Admin centers > Copilot. This opens the Copilot management dashboard.
  2. Navigate to the Agents section
    In the left navigation pane, select Agents. A list of all Copilot agents in your tenant appears, including agents built in Copilot Studio.
  3. Select the agent to assign
    Click the agent name. The agent details page opens, showing its description, data sources, and current assignment status.
  4. Configure assignment scope
    In the Assignment section, choose All users to make the agent available to everyone with a Copilot license. To restrict access, select Specific users or groups and then add one or more security groups. Click Save.
  5. Enable the agent for Office apps
    Scroll to the Applications section. Check the boxes for Word, Excel, and PowerPoint. If you want the agent only in certain apps, uncheck the others. Click Publish.

The agent appears in the Copilot pane of the selected apps within 15 minutes. Users must close and reopen the app to see the new agent.

ADVERTISEMENT

Steps to Assign Agents via Copilot Studio Channels

Copilot Studio provides an alternative method to assign agents. This method is useful when you want to configure agent behavior per channel, such as adding a custom greeting or limiting the number of conversations.

  1. Open Copilot Studio
    Go to copilotstudio.microsoft.com and sign in with a Copilot Studio license. Select the agent you want to assign from the Agents list.
  2. Go to the Publish section
    In the left menu, select Publish. Then click Channels.
  3. Add the Microsoft 365 channel
    Click Add channel and choose Microsoft 365. This channel controls where the agent appears in Copilot experiences.
  4. Configure channel settings
    In the channel configuration pane, toggle Enable this channel to On. Under Applications, check Word, Excel, and PowerPoint. Optionally, set a custom Agent name that appears in the Copilot pane. Click Save.
  5. Publish the agent
    Return to the Publish tab and click Publish. The agent becomes available in the selected Office apps after a few minutes.

Changes made in Copilot Studio override the admin center assignment for the same agent. If you enable an agent in the admin center but disable it in Copilot Studio channels, the agent will not appear in Office apps.

How Users Activate an Agent in Word, Excel, or PowerPoint

After you assign an agent, users need to activate it in the app. The process is identical across Word, Excel, and PowerPoint.

  1. Open the Copilot pane
    In any Office desktop or web app, click the Copilot icon on the ribbon. The Copilot pane opens on the right side of the window.
  2. Open the agent picker
    At the top of the Copilot pane, click the Agents button, which looks like a small robot icon or the word Agents. A dropdown list shows all assigned agents.
  3. Select the agent
    Click the agent name. The Copilot pane switches to that agent, showing its name and description. The agent is now active for all prompts you type in that pane.
  4. Start using the agent
    Type a question or command in the chat box. The agent responds using its configured data sources. To switch back to the default Copilot, click the Agents button again and select Copilot.

The agent remains active for the current session. Closing the document or restarting the app resets the pane to the default Copilot.

Common Mistakes and Limitations When Assigning Agents

Agent does not appear in the Copilot pane

This usually happens when the agent is not published to the Microsoft 365 channel in Copilot Studio or the assignment scope in the admin center excludes the user. Verify that the user has a Microsoft 365 Copilot license and that the agent is assigned to their security group. Also confirm that the agent is enabled for the specific app. Wait 15 minutes after publishing and restart the Office app.

Agent responds with general Copilot answers instead of custom data

The user may not have selected the agent in the Copilot pane. The default Copilot chat does not use agent data sources. Instruct users to click the Agents button and choose the correct agent. Also check that the agent’s data sources in Copilot Studio are properly configured and indexed.

Agent works in Word but not in Excel

The agent may be assigned only to Word in the admin center or Copilot Studio channels. Open the agent’s assignment settings and verify that Excel is checked. If the agent uses connectors that Excel does not support, such as certain SharePoint list queries, the agent may fail to load. Test the agent in Excel with a simple prompt to confirm basic functionality.

Users cannot see the Agents button in the Copilot pane

The Copilot pane in some versions of Office may not show the Agents button if no agents are assigned. Assign at least one agent to the user’s group and ensure the agent is published. If the button still does not appear, update Office to the latest monthly channel version. The Agents button requires Version 2406 or later for Windows and Version 16.87 or later for Mac.

Item Admin Center Assignment Copilot Studio Channel
Purpose Global publishing and user group targeting Per-agent channel configuration and advanced settings
App selection Checkboxes for Word, Excel, PowerPoint Checkboxes for Word, Excel, PowerPoint plus other channels
User targeting All users or security groups Inherits admin center scope unless overridden
Override behavior Base assignment Overrides admin center if channel is disabled
Propagation time Up to 15 minutes Up to 15 minutes after publish

Both methods can be used together. The admin center controls who sees the agent, and Copilot Studio controls where the agent appears. For most scenarios, use the admin center for assignment and Copilot Studio only when you need channel-specific settings.

Now you can assign Copilot agents to Word, Excel, and PowerPoint using the Microsoft 365 admin center or Copilot Studio channels. Start by publishing one agent to a test group and verify it appears in the Copilot pane. After confirming the agent works correctly, expand the assignment to all users. To manage multiple agents efficiently, create a naming convention that includes the app name, such as HR Agent Word, so users can identify the correct agent for their task.

ADVERTISEMENT