When you’re working across multiple spreadsheets, the alternative to using this function is typically a mix of constant ...
If Excel is not recognizing functions after reboot, change calculation settings, disable Show Formula, run Excel ...