Seems to me that you probably had an add-in installed in 2003 called
pcas97.xla, but that you haven't installed the same add-in in 2007.

Alternatively, if the ProdLookup function is actually a macro within
the workbook then you may need to change the security settings in Excel
2007.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup