It sounds like your worksheet function(s) are sometimes in the workbook and sometimes in a different one. Or to put it another way, you have a workbook (call it Here.xlsm) that has the code for func(), and sometimes you're trying to call it from Here.xlsm and sometimes from There.xlsx. I'm not saying that's what's going on, but that would at least explain why "=func()" is sometimes translated to "=drive:\\path\filename!func()".
Or wait, you say the filename has an extension of .xlxa (or did you mean .xla?). I don't use that extension much (where "not much" is pronounced "not ever, I think"), but maybe this means sometimes you have that add-on file open in Excel and sometimes you don't?
|