Thanks for the detailed scenario. Based on the current Microsoft 365/Copilot Studio capabilities:
- Can a Copilot Studio agent be accessed directly from Copilot for Excel?
Yes, a Copilot Studio agent can be published to the Microsoft 365 Copilot channel and made available to users. However, this should not be interpreted as the agent being natively embedded as an Excel Copilot skill.
- What is the recommended architecture?
The recommended pattern is:
Excel → Microsoft 365 Copilot → select/@mention the Copilot Studio agent → agent performs the specialised task
The custom agent can then use actions/Power Automate/connectors to retrieve and compare the required SharePoint files.
- Can Excel Copilot handle normal questions while the custom agent handles specific requests?
Yes, but I would not rely on automatic routing. Excel Copilot can continue handling normal Excel questions, while users explicitly invoke the specialised agent when they need functionality such as workbook comparison.
- Can the custom agent be invoked from within Excel?
The supported approach is to make the agent available in Microsoft 365 Copilot and have users explicitly select or @mention it where that experience supports agent invocation. I would not describe automatic skill-based routing from Excel Copilot to a Copilot Studio agent as currently supported.
- Does this work with .xlsb files in SharePoint?
.xlsb files are supported by Excel/SharePoint scenarios, but for your specific requirement—comparing two workbook versions—I would recommend a dedicated action/flow/backend process rather than relying on the files being treated as Copilot Studio knowledge.
In short: Yes to publishing the agent to Microsoft 365 Copilot; no clear support for automatic routing from Excel Copilot; and for .xlsb comparison, use a deterministic processing flow/action.