Got a custom .XLA called "Function.xla" (Lousy name... but I didn't choose
it...)

It contains code to compute rolling rates of return.

It's been working fine for all users for years and years.

Now one user is having a problem.

The problem presents as the "ROR" calculation showing up as a fully-qualified
path and an error message that pops when they try to invoke the computation. The
error message is to the effect that there's already a copy of Function.xla open
and Excel is trying to open another copy.

Same thing's happening in an MS Access app on that user's PC - that is creating
Excel spreadsheets. I coded around the error in the MS Access app by just
doing a Resume Next if/when that error popped.


Anybody got an idea what the root cause is?

I'm thinking something to do with multiple copies of the .XLA on this user's
computer coupled with some Excel parm that points to a default folder for
opening such things.... Plus, maybe, some explicit reference in the Excel
spreadsheets to a different folder.
--
PeteCresswell