Excel 2007 sheet UDF return #Name in Excel 2003

[Narendra Kumar]

Hello,
i have created a automation addin in excel that uses udf; we have a typical
problem; if we created a worksheet in excel 2007 with our udf and opened in
excel 2003; on opening the udf are prefixed with progid; when we refresh the
worksheet to calculate it returns the value as #NAME; it is not happening
for all the worksheets saved in 2007; there is one particular sheet that
gives this problem and intermittently(rarely we have seeen with other sheets
saved in 2007)
Excel 2007 version was 12.0.6514.5000 SP2 MSO(12.0.6425.1000)

Note: when i rename the worksheets saved in 2007 as zip file for example
"a.xlsx" to "a.zip" and open the sheet1.xml (content of the zip file) i
could see the formulas are prefixed with _xll; where as in the case of the
problematic sheet prefix is missing

It would be of great help if some one could help on this


Thanks
Narendra

 

[Niek Otten]

Hi Narenda,

It is not clear to me what exactly you are doing. And I'm not sure it has to
do with the Excel version.

Do read this article about distributing UDFs and Macros by Excel-MVP Jan
Karel Pieterse.

If this does not help you, post again with more details and code text.

 

[Niek Otten]

I meant this.......

http://www.jkp-ads.com/Articles/DistributeMacro00.asp

 

[Narendra Kumar]

Hi

Thanks for the reply; the issue is when i save my udf is excel 2007 and open
the same work book in Excel 2003; the udf cells are containing the Value as
#NAME;
I could notice this with Excel 2007 version 12.0.6514.5000 SP2
MSO(12.0.6425.1000) intermittently

Thanks
Naren

 

[Don Guillett]

Post your udf