Forum Discussion
copilot app is unable to edit an excel file and save a new version
I asked copilot to review an excel file I created and add worksheets with dashboard etc; it does the analysis, suggests the solution but when I ask to save a new edited version comes up with all kinds of limitations.. example of message :
I need access to the physical workbook file in the execution workspace, not just the extracted workbook content that I can read.
What I currently have is access to the contents of "book2" , including all sheets and rows
What I do not have is a file path that allows me to save a modified workbook and return a new Excel file.
This is exactly the distinction you were asking about earlier:
- ✅ I can inspect and analyse "book2".
- ✅ I can design the full V2 architecture you specified.
- ❌ In this session I cannot yet create and return the modified .xlsx because the actual uploaded file is not available in the workbook-editing workspace.
I save files on OneDrive and have MS365 Family subscription
, similar limitations with all MS files
is it a licence issue?
1 Reply
That response does not establish a licensing problem: it describes what the chat claims it can access. Reading workbook content is different from making changes in an Excel editing session.
Microsoft lists Microsoft 365 Family with an AI credits plan as eligible for Copilot in Excel. Check the entitlement on the account signed into Excel before buying another subscription.
Create a copy of the workbook, open it in Excel on Windows, Mac or the web, then open Copilot and choose edit mode. Microsoft's documentation distinguishes edit mode, which changes the workbook directly, from chat mode, which keeps responses in the conversation. Set Calculation Options to Automatic, as required for editing.
Start with one change, such as adding a dashboard worksheet, and inspect the resulting sheets, formulas and charts before saving. If edit mode is unavailable, give support your Excel version, account entitlement and screenshot of the Copilot experience.