Making Excel Services UDFs work on Excel 2007 - Part 1

Making Excel Services UDFs Work in Excel 2007

Microsoft Excel 2007 (nee Excel 12) — Fri, 01 Sep 2006 20:48:39 GMT

Shahar Prish, one of the developers on the Excel Services team, has recently posted a few entries on...

re: Making Excel Services UDFs work on Excel 2007 - Part 1

Rebecca — Mon, 18 Sep 2006 06:31:29 GMT

Well done!
[url=http://kocnsmfs.com/rpul/kttd.html]My homepage[/url] | [url=http://jodzsbcg.com/unal/trei.html]Cool site[/url]

re: Making Excel Services UDFs work on Excel 2007 - Part 1

Debbie — Mon, 18 Sep 2006 06:32:11 GMT

Great work!
<a href="http://kocnsmfs.com/rpul/kttd.html">My homepage</a> | <a href="http://kygqdbev.com/uugv/udtl.html">Please visit</a>

Pre-requisites

LuisBE on Services — Fri, 29 Sep 2006 08:49:01 GMT

Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good.
One...

re: Making Excel Services UDFs work on Excel 2007 - Part 1

mgr — Wed, 03 Jan 2007 01:00:07 GMT

Does this work in excel cleints installed outside sharepoint environment? for example on excel 2007 running on xp

re: Making Excel Services UDFs work on Excel 2007 - Part 1

Shahar — Wed, 03 Jan 2007 01:08:51 GMT

It should, yeah.

If you have any specific problems, let me know.

re: Making Excel Services UDFs work on Excel 2007 - Part 1

stswordman — Mon, 22 Jan 2007 10:53:52 GMT

hi salis.

Could you post the screen shot of "File menu "t and “Excel Options” ? I can't find them in excel 2007

re: Making Excel Services UDFs work on Excel 2007 - Part 1

stswordman — Mon, 22 Jan 2007 10:54:35 GMT

hi salis.

Could you post the screen shot of "File menu "t and “Excel Options” ? I can't find them in excel 2007

re: Making Excel Services UDFs work on Excel 2007 - Part 1

Shahar — Mon, 22 Jan 2007 22:11:21 GMT

In Excel 2007, you will see a circle at the top right corner. It may even blink at you - it has the Office Logo on it. Click it. At the bottom of the menu that comes up there's an "Excel Options" button. Click that.

re: Making Excel Services UDFs work on Excel 2007 - Part 1

TS — Wed, 07 Feb 2007 23:50:16 GMT

How did you come up with the Class ID as below, did you make it up?

const string ClsId = "D08A3087-F858-4103-8C52-66B2D2898346";

re: Making Excel Services UDFs work on Excel 2007 - Part 1

Shahar — Thu, 08 Feb 2007 00:07:01 GMT

You will need to generate your own using the Guidgen tool (or the UI GUID generator you can easily find in the Tools menu option in Visual Studio)

re: Making Excel Services UDFs work on Excel 2007 - Part 1

TS — Thu, 08 Feb 2007 01:43:02 GMT

thanks, while i still can't get the function to work properly, I need to be able to replace the dll. How do i get the system from locking the dll, even after unregistering it?

re: Making Excel Services UDFs work on Excel 2007 - Part 1

Shahar — Thu, 08 Feb 2007 02:02:56 GMT

Exit Excel.

re: Making Excel Services UDFs work on Excel 2007 - Part 1

SP — Tue, 13 Feb 2007 17:07:27 GMT

I have followed all th steps mentioned but while opening the excel sheet in Excel am getting following error.

"values does not fall on the esxpected range". Is there any restrictions like we need to select the range in excel workbook exactly same as the columns and rows of sharepoint list and call the function.

will it be a problem if i select less or more than the list dimensions.Please let me know about this as i got stuck here and not to display the list in excel workbook.

Thanks,

re: Making Excel Services UDFs work on Excel 2007 - Part 1

Shahar — Tue, 13 Feb 2007 22:09:26 GMT

Can you post your code? (Just the code that builds the result you send back from the UDF)

re: Making Excel Services UDFs work on Excel 2007 - Part 1

SP — Wed, 14 Feb 2007 14:26:46 GMT

Thanks shahar,

I am very happy that my problem got resolved as i was not passing parameters in calling t he UDF correctly..

Erweiterungsbibliothek für Excel-Tabellenfunktionen in Managed Code schreiben

Open XML, VSTO, Deployment, .NET und anderes — Wed, 09 Apr 2008 15:58:29 GMT

Hin und wieder werde ich gefragt, ob man mit VSTO auch Tabellenfunktionen für Excel schreiben kann. Nun,