#Name?
 

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.

#Name?
 

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.

.

#Name?
 

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.

.

#Name?
 

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.

.


.