Forum Discussion
=_xlfn._xlws.SORT added to some PCs but not others
Hello,
So we have an efficiency tracker spreadsheet and it contains a hidden sheet with a set of formulas that are contained here. For certain Windows 10 PCs, they are able to view this spreadsheet properly with the formulas. However, we still have Windows 7 PCs that cannot view the spreadsheet properly and the file prefix: "=_xlfn._xlws" is added to the formulas while on the PCs it is working on this field is not present. I do have a Windows 10 PC with a different Office 365 subscription than my colleagues and the spreadsheet shows these same problematic fields ("=_xlfn._xlws.SORT"). Could you help me out?
Thank you,
Chris
Hello,
I have the same problem. Version of Excel seems the same.
Do you find a solution ? Is tehere a way to update Excel on old version of Windows?
Hi Chris,
If _xlfn that means this concrete version of Excel doesn't support that function. You may check if open new Excel file and start typing =SORT in any empty cell. If function is listed in prompt it is supported, otherwise not.
Hello,
Do you suggest that Excel for Windows 7 do not support new functions?
365 is not supported on Windows 7 for few years Windows 7 end of support and Microsoft 365 Apps - Microsoft 365 Apps | Microsoft Learn
