=_xlfn._xlws.SORT added to some PCs but not others

Copper Contributor

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

1 Reply

@Chris_Guffey 

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.

 

image.png