I don't know what to tell you. When I open the workbook, it works. The only reason to get a #NAME error is if excel doesn't know of the function name or the name of one (or more) of the parameters. I don't think that if you fail to enable macros you would get a #NAME error - you would get some other kind of error.