You asked Copilot to generate an Excel file, it said it was done and gave you a download link, and clicking that link produces "This item might not exist or is no longer available" — or a sandbox URL that clearly doesn't work. This is a known, recurring limitation of how Copilot generates files in chat mode, not something wrong with your account.
Why this happens
When Copilot in chat mode (Copilot.microsoft.com, the Copilot app, or Copilot Chat in Teams) generates a file, it creates it in a temporary sandbox environment rather than in your actual OneDrive. The link it gives you points to this temporary location, which either:
- Expires quickly (sometimes within minutes)
- Was never a real, accessible URL in the first place — some versions generate placeholder links like
https://sandbox:...that were never meant to resolve - Points to a location you don't have access to, even though Copilot thinks you do
This is a fundamental limitation of Copilot in chat/assistant mode — it's not the same as Copilot running inside Excel with direct access to your OneDrive. Enabling AutoSave in Excel doesn't help here because the file was never in your Excel in the first place.
Fix 1: Ask Copilot to show you the data instead of a file
If Copilot can't give you a working download link, ask it to display the data directly in the chat instead:
Instead of a file, show me the data as a table in the chatPaste the data here so I can copy itShow me the spreadsheet content as text
Once the data is visible in the chat as a table, you can select it all, copy it, paste it into a blank Excel sheet, and use Data > Text to Columns or Excel's paste formatting options to clean it up. It's an extra step but it's reliable — unlike the download link.
Fix 2: Ask Copilot for the data in CSV format
CSV data is plain text, which Copilot can display directly in the chat without needing to generate a file:
Give me the data as CSV text I can paste into ExcelFormat the output as comma-separated values
Paste the CSV text into a blank .txt file, save it, then open it in Excel — it will import cleanly into columns. Or paste directly into Excel and use Data > Text to Columns with comma delimiter.
Fix 3: Use Copilot inside Excel directly
The most reliable way to get Copilot to work with Excel files without broken links is to use Copilot inside Excel itself (the Copilot button in the Home tab ribbon) rather than in chat mode. Inside Excel, Copilot works directly on your open workbook — it doesn't need to generate files or provide download links because it's already inside the file. Everything it does goes directly into your spreadsheet.
This requires a Microsoft 365 Copilot licence (not just Copilot Chat), but it's the version that was designed for spreadsheet work. If file generation with working links is important to your workflow, this is the version to request from your IT admin or upgrade to.
Worth knowing: Copilot in chat mode was designed for conversation and content generation, not for creating and persisting files. It was never fully built for reliable file delivery — the download link behaviour reflects a capability gap that has existed since launch and hasn't been fully resolved. Using it inside Excel is the intended path for spreadsheet work.
Fix 4: If you got the file once, click the link immediately
If Copilot does generate a working link in a future session, click it immediately — don't leave the chat or wait. The temporary file location can expire within minutes. Download the file as soon as you get the link, then save it to your own OneDrive or local drive before continuing.
The bottom line
Broken download links from Copilot in chat mode are a known limitation, not a fixable error on your end. The practical workarounds are: ask for the data as a table or CSV in the chat itself, or switch to using Copilot inside Excel where file generation isn't needed. If you need reliable Excel file creation from Copilot, the in-app version is the right tool — the chat version isn't built for it.