Excel Table connection

Hi, I am very new to appsheets. I have a set of excel tables from O365 for my data source. I am trying to add a table as a datasource but keep getting this message:

The spreadsheet for ‘TeamLeaderApp(1)’ uses an unsupported formula : Excel function ‘_xlfn.IFS’ is not supported in formulas.

From searching it seems like it is the xlfn portion that is an issue? I do have IFS statements in other tables but these are not connected to the table in question. Can anyone provide a solution to this?

AppSheet must load the entire file even if your app only uses a single table.