Teams is changing Excel Formulas

Occasional Visitor



This might be a simple fix for someone but I have an excel worksheet with the formula =XLOOKUP(1,AD37:AD39,AC37:AC39) which works perfectly within excel on the desktop but when I upload it to teams it adds the @ sign =@XLOOKUP(1,AD37:AD39,AC37:AC39) and breaks the formula. Why would it do this? I then have to go into the excel file on teams to delete the @ for it to work..  Any tips/help would be appreciated.

0 Replies