please help there's a problem using a user defined function,
=GetPOPData("AB(100)","CD(G)") within an xla file that is installed and works
fine.

The problem is that occasionally when I open a spreadsheet that contains
these functions I get the #Name? Error, if I shut down the sheet and reload
it, it works and is able to retain the correct values, the function needs to
retain the values when I first open it without having to force a recalc.

I have searched high and low and no one else seems to have come across this
problem, I am a bit confused because at times it works fine and other times I
get the #Name? could it be the order in which Excel loads the addin.

Hi Victor,

could you post the function code? maybe the internal order
of the function causes the error...


Best

Markus


-----Original Message-----
please help there's a problem using a user defined
function,
=GetPOPData("AB(100)","CD(G)") within an xla file that is
installed and works
fine.

The problem is that occasionally when I open a
spreadsheet that contains
these functions I get the #Name? Error, if I shut down
the sheet and reload
it, it works and is able to retain the correct values,
the function needs to
retain the values when I first open it without having to
force a recalc.

I have searched high and low and no one else seems to
have come across this
problem, I am a bit confused because at times it works
fine and other times I
get the #Name? could it be the order in which Excel loads
the addin.

.

Thanks, the function itself doesn't do much, I still have the problem if I
set the return value to a constant e.g. 1 without any other calculation,
thanks for your help

Hi Victor,

could you post the function code? maybe the internal order
of the function causes the error...


Best

Markus


-----Original Message-----
please help there's a problem using a user defined
function,
=GetPOPData("AB(100)","CD(G)") within an xla file that is
installed and works
fine.

The problem is that occasionally when I open a
spreadsheet that contains
these functions I get the #Name? Error, if I shut down
the sheet and reload
it, it works and is able to retain the correct values,
the function needs to
retain the values when I first open it without having to
force a recalc.

I have searched high and low and no one else seems to
have come across this
problem, I am a bit confused because at times it works
fine and other times I
get the #Name? could it be the order in which Excel loads
the addin.

.

Hi Victor,

well, nevertheless I could imagine some problems
especcially concerning .select and .activate methods
within the function code... sometimes Excel is very
sensitive if there is a wrong worksheet activated when you
open the workbook - and the functions fail, showing the
NAME-error...

Best

Markus


-----Original Message-----
Thanks, the function itself doesn't do much, I still have
the problem if I
set the return value to a constant e.g. 1 without any
other calculation,
thanks for your help

Hi Victor,

could you post the function code? maybe the internal
order
of the function causes the error...


Best

Markus


-----Original Message-----
please help there's a problem using a user defined
function,
=GetPOPData("AB(100)","CD(G)") within an xla file that
is
installed and works
fine.

The problem is that occasionally when I open a
spreadsheet that contains
these functions I get the #Name? Error, if I shut down
the sheet and reload
it, it works and is able to retain the correct values,
the function needs to
retain the values when I first open it without having
to
force a recalc.

I have searched high and low and no one else seems to
have come across this
problem, I am a bit confused because at times it works
fine and other times I
get the #Name? could it be the order in which Excel
loads
the addin.

.


.