Copilot for Excel not able to access data

I have a simple excel file which has two data tables both formatted as individual excel tables. I click into a cell of one of the tables, hit analyze and am presented with a couple of suggestions. On clicking one of those I get the following message.. "I'm sorry, but I'm having trouble accessing your data right now. Could you please try again later?" after going through the process and finalizing etc. The file is stored on OneDrive, autosave is turned on. I have tried with a different file and get the same error