Excel Table connection

[jevinsw]

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?

[Steve · Accepted solution]

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