"The problem is that sometimes when excel starts up (I am using excel 2007 and the file is a 2003 file format) the above mentioned function with get replaced with {='P:\\Program Files\\Common Files\\ArchestrA\\HistClient.xla'!wwWideHistory2( ....)} because I am assuming it can not find the add in workbook." . . . .