Shahar Prish, one of the developers on the Excel Services team, has recently posted a few entries on his blog that explain how to make Excel Services UDFs work in Excel 2007. (UDF stands for â€œuser defined functionâ€, which refers to custom functions that you can create to supplement Excelâ€™s set of intrinsic worksheet functions (SUM, MIN, MAX, etc.). UDFs are generally used to create calculation libraries, or to import data into Excel sheets in custom ways. See here, , and here for some earlier posts on the Excel 2007 blog about UDFs on Excel client and Excel services.)
Here is the opening of Shahar’s first post.
I have made a few posts about UDFs over the past couple of months. One of the things I neglected to explain is how to make server targeted UDFs work on the client. Among other reasons why one would want that, is the fact that itâ€™s useful to actually see what the results of your workbook is before you publish it to the server.
This series of posts will concentrate on one of the ways that this can be achieved. While there are ways that are more efficient (perf wise), the one I will present is probably the easiest to do yourself.