#Name error appears when excel file is opened by other user

Originally Posted by Andy Pope

I would only except the #NAME to be macro related if you were using UDF(User Defined Functions).

Without the workbook we can only make suggestions

Okay, I have attached the workbook now.
I'm not familiar with UDF, but let me know if that is the problem. Thanks Andy