Excel formula upload

Hello Yves39,

if I understood (translated) your question correct, then these are possible reasons why you are getting the #NAME error when you load formulas from a saved file:

• The formula may be using a name that is not defined in the current workbook.
• The formula may be using a function that is not available in the current version of Excel.
• The formula may be using a reference to a cell or range that is not present in the saved file.

To troubleshoot the issue, you can try the following:

• Check the formula to make sure that it is using a valid name or function.
• If the formula is using a named range, make sure that the named range is defined in the current workbook.
• If the formula is using a reference to a cell or range, make sure that the cell or range is present in the saved file.

If you have tried these steps and you are still getting the #NAME error, you can try the following:

• Open the saved file in a previous version of Excel. If the formulas work correctly in the previous version, then the problem is likely due to a compatibility issue.
• Save the file in a different format, such as CSV or XLSX. This may help to resolve the issue.
• Use the Formula Auditing tools to help you identify the source of the error.
• Use the Trace Error feature to step through the formula and identify where the error is occurring.
• Use the Error Checking feature to identify potential errors in your formulas.