Excel sheets are built visually so there is absolutely no sane way to parse them. Just the same thing as trying to restructure a pdf at the end of the day.
They’ve removed that limitation now, I think. That said, I still haven’t found any use-case for Copilot within an Excel workbook that works (probably because I’ve only ever asked it to do very difficult things since I don’t need it for easy stuff). So there’s that.