Calling a function in another project from within a cell formula

E

Ellis Horowitz

Hi All,

I am running into an interesting problem and I was hoping that there
was an easy solution. I have a personal.xls spreadsheet that contains
a set of functions and subroutines. I have created a function in that
spreadsheet that I want to use across moany other spreadsheets. When
I try to use it in a formula within a cell, I get back #name? unless
the function is defined within the project specific to the
spreadsheet. What am I doing wrong here?

Thanks in advanc for any help.

Ellis
 
S

SunTzuComm

Hi, Ellis!

Try coding the formula like this:

=personal.xls!your_function(some_parameter)

The personal.xls workbook must be open for this to work.

Regards,
Wes
 
Top