SOLVED

excel technical issues

%3CLINGO-SUB%20id%3D%22lingo-sub-1547114%22%20slang%3D%22en-US%22%3Eexcel%20technical%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1547114%22%20slang%3D%22en-US%22%3EMy%20excel%20cannot%20create%20graphs%2C%20sum%20for%20equations%20and%20calculate%20the%20mean%2C%20median%20and%20descriptive%20statistics%2C%20it's%20excel%202016%20and%20it%20cannot%20highlight%20correctly%20the%20selected%20data%20to%20create%20a%20table.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1547114%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAnalytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMessaging%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1548942%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20technical%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1548942%22%20slang%3D%22en-US%22%3EHi%2C%3CBR%20%2F%3E%3CBR%20%2F%3EAre%20you%20trying%20to%20do%20these%20things%20in%20Excel%20from%20within%20Teams%2C%20so%20the%20web%20version%20of%20Excel.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20so%2C%20it%20is%20worth%20pointing%20out%20that%20the%20web%20version%20does%20not%20have%20the%20full%20functionality%20of%20the%20desktop%20version.%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20in%20the%20first%20instance%20I%20would%20choose%20the%20option%20the%20open%20in%20Excel%20and%20see%20if%20the%20same%20issue%20is%20present%3F%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3E%3CBR%20%2F%3EHenry%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1553542%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20technical%20issues%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553542%22%20slang%3D%22en-US%22%3EI%20figured%20out%20the%20problem%2C%20excel%20does%20not%20accept%20full%20stops%2C%20it%20only%20accepts%20commas%2C%20that%20was%20the%20problem%2C%20also%20I%20don't%20know%20how%20to%20change%20my%20decimal%20settings.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
My excel cannot create graphs, sum for equations and calculate the mean, median and descriptive statistics, it's excel 2016 and it cannot highlight correctly the selected data to create a table.
2 Replies
Highlighted
Best Response confirmed by ThereseSolimeno (Microsoft)
Solution
Hi,

Are you trying to do these things in Excel from within Teams, so the web version of Excel.

If so, it is worth pointing out that the web version does not have the full functionality of the desktop version.

So in the first instance I would choose the option the open in Excel and see if the same issue is present?

Thanks

Henry
Highlighted
I figured out the problem, excel does not accept full stops, it only accepts commas, that was the problem, also I don't know how to change my decimal settings.