Apr 13 2020 06:23 AM
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
Apr 13 2020 06:41 AM
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.