I got bitten by this confusing UX. The spreadsheet must be in OneDrive for copilot to use it as context. It’s actually quite useful.