I have made a PAN checking function in excel.
This will check whether PAN no. supplied is correct ot not.
To check this in cell type formula =ispanvalid(A1)
where A1 is cell reference in which pan no. is typed.
Also make sure that your MACRI is enabled.
Pl check & confirm about the functioning of the same & error if any.