Copilot Permission Problems

How to Give a BizChat Agent Access to a SharePoint Excel File

Maira Mehtab Sep 22, 2026 869 views

Question details

The user needs to grant a Microsoft BizChat agent access to a specific Excel file hosted on SharePoint.

Product: Microsoft Copilot / BizChat
Device & OS: not provided
Scenario: Attempting to add an Excel file from SharePoint as context for a BizChat agent session.
Observed behavior: The BizChat agent cannot access the file via the provided SharePoint link, and the paperclip icon for adding context is disabled.

Before you start

Ensure you have the necessary site owner or SharePoint administrator permissions to view and modify site access and agent permission settings.

Solution 1Recommended

Review SharePoint Agent Access and Permissions

Verify that both the user account and the BizChat agent have the correct permissions to access the specified Excel file in SharePoint.

BizChat relies on Microsoft Graph to access files. If the file is restricted or the agent is blocked at the tenant or site level, it will not be able to read the Excel file.

Open SharePoint Settings

Navigate to the SharePoint site where the Excel file is stored and click on the gear icon to open Settings.

Check File Access

Locate the Excel file, select 'Manage Access', and ensure that your user account has explicit permission to view and share the document.

Verify Agent Permissions

Access the SharePoint Admin Center and review Microsoft's documentation for managing access to SharePoint agents to ensure they are allowed to read site content.

Solution 2

Consult Microsoft Q&A for Specialized Help

If permissions appear correct but the paperclip icon remains disabled, reach out to Microsoft's specialized support communities.

Free Microsoft Office alternative

Try WPS Office for Seamless Excel File Management

While specialized AI agents like BizChat require complex SharePoint permission configurations, standard file management and data analysis shouldn't be a hassle. WPS Office offers a lightweight, highly compatible alternative to Microsoft Office, making it easy to create, edit, and analyze spreadsheets for free without complex enterprise settings.

1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite.
2. Open Your Spreadsheets: Launch WPS Spreadsheet and easily open your existing Excel files directly.
3. Use WPS AI: Click the WPS AI icon in the ribbon to instantly chat with your document, summarize data, and generate formulas without configuring complex agent permissions.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Free and lightweight alternative to heavy enterprise suites.Built-in WPS AI for instant data analysis and document summarization without complex permission setups.Familiar user interface for a seamless migration experience.

Frequently Asked Questions

Why is the paperclip icon disabled in BizChat?

The paperclip icon may be disabled if the current chat session does not support file attachments, if your organization's IT policies restrict data sharing with AI agents, or if there is a temporary glitch requiring a page refresh.

Can BizChat access files stored outside of SharePoint or OneDrive?

Typically, Microsoft 365 Copilot and BizChat require files to be stored within the Microsoft 365 boundary (such as SharePoint or OneDrive) to securely access them via links and respect organizational data policies.

Do I need admin rights to fix BizChat agent access to a file?

Yes, modifying SharePoint site permissions, tenant-level data sharing policies, or agent access settings usually requires site owner or SharePoint Administrator privileges.

How do I check my SharePoint file permissions manually?

Right-click the Excel file in your SharePoint document library, select 'Manage Access', and review the list of users, groups, and links to verify who has permission to view or edit the file.

Microsoft Copilot Issues