#UNKNOWN! usually means a workbook uses a function your Excel version doesn't support — for example opening a file that uses newer dynamic-array or Microsoft 365 functions in an older build.
Update Excel
Update to a version (or Microsoft 365) that supports the function.
Use a compatible formula
Replace the newer function with an equivalent your version supports.
Update Excel to a version that supports the function, or rewrite it with a compatible formula.