Either the user-defined function GetDistance isn't found or CRW isn't found.
You can tell which by selecting one of the cells with #NAME? in, then clicking the Evaluate Formula button in the Formula Auditing section of the Formulas tab of the ribbon. Step through resulting dialogue box and it should be obvious which is missing.


We'd really neeed to see a workbook. Can you attach one here?