Posts about B2TR

Excel Services Beta2 Technical Refresh (b2tr) has a few new features, featurettes and fixes that were not available on B2. In the next week or two I will make a few posts about those – mainly the ones I worked on – for most, I will try and also explain the reasoning that drove us to make these changes.


Stay tuned.

Comments (2)

  1. TS says:

    Hello, i have seen some of your blogs and believe you are someone who can shed some light. I am working on getting a demo running to show mgmt the powers of the new excel services (This was the most applicable post I found to leave a comment in).

    I have a issue with excel svcs. that i have gotten diff. info about on its supported features. I have read how it can use an office data connection located in a sharepoint data connection library to access data in the file. I have also read that this feature may not be available in B2TR or even the first RTM. All I get when i try to use one of these connecting to a DB is:

    Unable to Load Workbook  

    The workbook that you selected cannot be loaded because it contains the following features that are not supported by Excel Services:

    External data ranges (also called query tables)

    Can you please tell me if this is supported now, and if it is, why do i keep getting this error?

    Thanks a bunch

  2. Shahar Prish says:

    Hello TS,

    With this version of Excel Services, Data tables (also called query tables) are not supported, as the error suggests.

    Together with not supporting VBA, this is probably the most painful cut we had to take. We knew it would be highly annoying for our users, but we didn’t think we would have been able to support it in the given timeframe.

    That said, we have a few workarounds, each with its own advantages and disadvantages, none as good as the original feature.

    The two basic ideas on how to do this are these:

    1. We have an add-in which programmatically transforms a Query Table into a Pivot Table with similar functionality. The pivot table will look more like a QueryTable than a PivotTable, however, some features will not be applicable to it.

    2. We have sample code for a UDF that returns relational data into the workbook.

    If you want, I can give you some help with either or both of these workarounds. You can use the "contact" featrue of the blog to answer me directly.