I have written a external references udf for the new sharepoint server by following the example here:
http://blogs.msdn.com/cumgranosalis/...rnalWBUdf.aspx
Now I am trying to replace the external references in the work book to post on server. As of now this is set up with the inbuilt excel external references function like this
=VLOOKUP(R5,INDIRECT(R$18),HLOOKUP($E6,INDIRECT(R$18),2,FALSE),FALSE)
where R18 = [workbookname]!worksheetname!namedrange
This works if i replace the above formula like this
=VLOOKUP(R5,ExternalWBUdf,HLOOKUP($E6,ExternalWBUdf,2,FALSE),FALSE) but i have about 2000 such functions in a single worksheet.I want to replace R18 with my udf, to simplify this transition but for some reason this is not working. It works for all other excel functions except for my udf. I have also posted in
http://forums.microsoft.com/msdn/Sho...=true&siteid=1