Teams is changing Excel Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2241810%22%20slang%3D%22en-US%22%3ETeams%20is%20changing%20Excel%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2241810%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20might%20be%20a%20simple%20fix%20for%20someone%20but%20I%20have%20an%20excel%20worksheet%20with%20the%20formula%26nbsp%3B%3CSPAN%3E%3DXLOOKUP(1%2CAD37%3AAD39%2CAC37%3AAC39)%20which%20works%20perfectly%20within%20excel%20on%20the%20desktop%20but%20when%20I%20upload%20it%20to%20teams%20it%20adds%20the%26nbsp%3B%40%20sign%20%3D%40XLOOKUP(1%2CAD37%3AAD39%2CAC37%3AAC39)%20and%20breaks%20the%20formula.%20Why%20would%20it%20do%20this%3F%20I%20then%20have%20to%20go%20into%20the%20excel%20file%20on%20teams%20to%20delete%26nbsp%3Bthe%26nbsp%3B%40%20for%20it%20to%20work..%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EAny%20tips%2Fhelp%20would%20be%20appreciated.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2241810%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%20Excel%20file%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi,

 

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
We support Ukraine and condemn war. Push Russian government to act against war. Be brave, vocal and show your support to Ukraine. Follow the latest news HERE