How to fix the #NAME? error in Excel after moving a file to another PC?

Check if the new computer has the third-party add-in that the formula depends on. Go to "File" → "Options" → "Add-ins" → "COM Add-ins" → "Go..." and activate it.

If the add-in is present but macros are disabled, user-defined functions will not work. When opening the file, click "Enable Content".

Also check named ranges via the "Name Manager" in the "Formulas" tab. Find a name with the value #REF! and specify a new correct range. If the problem is not this, the formula may be using an outdated function. Here's how to replace outdated formulas for importing data with modern ones.

🔗 Source: excel.rf