Building and customizing solutions using Microsoft 365 Copilot APIs and tools
Save the workbook to OneDrive, open it in Excel, and use Copilot’s Allow editing mode instead of working with the uploaded attachment in the standalone Microsoft 365 Copilot Chat.
Uploading a local .xlsx file to Copilot Chat can provide analysis, but that does not necessarily give the chat an editable workbook session. Direct changes are performed through Copilot in Excel, where editing mode can modify cells, formulas, sheets, charts, and formatting. Chat-only mode intentionally keeps results in the conversation rather than writing them into the workbook.^1^
Supported workflow
- Open the
.xlsxfile in Excel. - Select File > Save As, and save it to OneDrive using the same Microsoft account used for Copilot.
- Open the OneDrive copy in:
- Excel for the web, or
- Excel for Windows/Mac.
- Select the Copilot button in the lower-right corner of Excel.
- Open the mode selector above the prompt and choose:
- Allow editing to let Copilot make changes immediately, or
- Plan to review the proposed operations before approving them.
- Enter a specific editing request, for example:
Add the analysis results to a new worksheet named “Summary.” Include the key findings, supporting data ranges, and a chart showing the main trend.
Copilot in Excel defaults to editing mode and performs approved work directly with Excel’s native features.^1^ Microsoft also identifies .xlsx as a supported workbook format for files stored in OneDrive.^2^
The analysis from the existing standalone chat may need to be copied into a new prompt in Excel; opening the workbook in Excel establishes the editable workbook context.
If Excel still reports that it cannot edit
Check these conditions in the opened workbook:
- Calculation mode: Select Formulas > Calculation Options > Automatic. Copilot editing is not supported when calculation is set to Manual.^3^
- File subtype: In File > Save As, ensure the type is Excel Workbook (
.xlsx), not Strict Open XML Spreadsheet. Strict Open XML is unsupported for Copilot editing.^3^ - Workbook restrictions: Remove sheet or workbook protection temporarily if editing is restricted.
- File complexity: If the workbook has many formulas or is unusually large, test with a smaller copy containing the relevant sheets. Microsoft recommends reducing or splitting complex spreadsheets when file processing fails.^2^
- Copilot access: If the Copilot button is absent in Excel, confirm that Excel is signed in with the account that has the eligible Microsoft 365/Copilot entitlement. Availability also depends on application, privacy, network, and organizational settings.^3^
Since multiple .xlsx uploads have produced the same result while analysis continues to work, repeatedly uploading them to the standalone chat is unlikely to change the outcome; the next step is to move the task into an editable Copilot session inside Excel.
References