I have a workbook that has many custom functions built into it. One
of the employees here found a bug that I am not sure how to resolve.
The spreadsheet is used to do estimates for the services we sell. So
we have a template and do a file-save-as to keep record of all the
estimates we have sent out. If you have two of the excel estimate
files open at the same time then the the functions get all messed up
and give you the wrong results in both sheets. Can someone advise me
on where I might start to track down this problem. I assume it has
something to do with the way the functions are setup and maybe even
how the variables are declared within each function, but I am not
sure.

I should note one test I did. I double clicked to open excel then do
file-open to open the first file. Next I double clicked to open excel
again then did file-open to open the second file. This method seems
to work fine, but does not seem like a good solution. It is too easy
to forget that you have to start excel a second time. Plus I would
like to better understand the problem.

Thanks in advance.

Bk