November 2006 - Posts

• Another tool for working around Excel Services not supporting QueryTable

  Abdullah Kavi (with some help from Bob Archer) from the Excel Test Team has taken Boaz's solution for converting query tables so that their data can be consumed in Excel Services and added quite a few features to it. In his own words: ---- I have created Read More... Posted Monday, November 27, 2006 3:02 PM by Shahar | 31 Comments Filed under: Excel Services Attachment(s): QueryTable Tools_Blog.zip

• Impersonating users inside UDFs

  In a previous post I described how UDFs can figure out who the user running them is. Luis already touched on how to impersonate a user, but has a very serious (but very easily fixable) bug in it. (Edit: Luis fixed the bug inside his post) In this post, Read More... Posted Thursday, November 09, 2006 9:00 AM by Shahar | 2 Comments Filed under: Development, Excel Services

• Nice article in CNet - shipping Vista

  http://news.com.com/Vistas+last+mile/2009-1016_3-6133357.html?tag=nefd.lede This is probably the first time I have seen an accurate portraiel of how shipping at Microsoft works. While the Vista process seems to be a little different than the Office one, Read More... Posted Wednesday, November 08, 2006 9:58 AM by Shahar | 0 Comments Filed under: Touchy Feely

• Office 2007 Party - Things to regret at a later date

  (Disclaimer: This post contains words, phrases and audio that may offend some people. Please hit your "back" key if you are easily offended by rude words) Last friday we had a party for the Office group. One of the things that we had there was this booth Read More... Posted Monday, November 06, 2006 3:38 PM by Shahar | 1 Comments Filed under: Touchy Feely

• Query Tables work-around for Excel Services

  Both in the internal distribution lists and on my blog, the two most insistent question we seem to be getting these days seem to be: 1. My workbook has a Query Table (relational data source in the form of a table) in it and it doesn't load on the server. Read More... Posted Friday, November 03, 2006 9:00 AM by Shahar | 10 Comments Filed under: Excel Services Attachment(s): ConvertToPivot.xlam