I have designed a spreadsheet on an English version of Excel 97 to be used by a user’s using a Dutch, German, or Swedish version of Excel 2000.
The problem arose with the date function called eomonth and workday that display and error message of”name” in the cell of the non-English versions. The Add-in Analysis Toolpak is installed and active.
Could anyone advise how I can get the non-English versions to recognise these functions?