LuisBE on Services

A blog maintained by Luis Bitencourt-Emilio (LuisBE) and geared toward Excel Services programmability and solutions. Focused on the v1 of Excel Services in Office 2007, and the ongoing planning of v2 in Office 14.

Excel Services Calculation Issue Update & Fix!

Please check out David's post for links to the fixes....

Author: LuisBE Date: 10/10/2007

Calculation Issue Post on Excel Blog

This same calculation issue affects Excel Services, and is being addressed concurrently....

Author: LuisBE Date: 09/26/2007

Dear Friends and Family, I recently accepted the challenge to raise funds to support the JDRF...

Author: LuisBE Date: 05/11/2007

Excel Services Team Looking for Customer Connections!

The Excel services team is looking for companies that are using Excel services and are willing to...

Author: LuisBE Date: 05/10/2007

New blog from an Excel Services Tester

Another one of our prolific Excel Services testers has started up a blog here:...

Author: LuisBE Date: 05/01/2007

Microsoft Office is Searching for Talented Devs!

Microsoft Office is looking for talented developers to work on cutting edge web-based technologies...

Author: LuisBE Date: 04/04/2007

Excel Services step-by-step guides

Technet now has some interesting tutorials for Excel Services. Check them out at...

Author: LuisBE Date: 03/13/2007

New MSDN Article on Extending Excel Services Through UDFs

From yours truly: Summary: Optimize version 1 of the Excel Services programmability framework to...

Author: LuisBE Date: 02/06/2007

Enable Paging in Your Array Formula UDFs

As I alluded to earlier, one way to overcome the limitation that array formulas do not dynamically...

Author: LuisBE Date: 02/01/2007

Consuming Business Data Catalog Entities in Excel Services

One of the coolest (only?) SharePoint external data features is the Business Data Catalog (BDC). The...

Author: LuisBE Date: 01/31/2007

Here are a few books being worked on about Excel Services:...

Author: LuisBE Date: 01/11/2007

New Excel Services MSDN Forum!

MSDN has created a forum for Excel Services related discussion, you can find it at:...

Author: LuisBE Date: 01/09/2007

v1 Feedback & Requests for v2 of Excel Services!

<UPDATE: Reworded the post to stay away from any legal issues :o) > We are currently working...

Author: LuisBE Date: 01/09/2007

Working Around Dimensional Limitations of Using Array Formulas for UDF Return Values.

As you have noticed, many of my samples below use an Array Formula in Excel to retrieve an array of...

Author: LuisBE Date: 01/09/2007

Using UDFs and Excel Formulas to Get a Query Table on Excel Services

As you may or may not know by now, one of the limitations in this version of Excel Services is the...

Author: LuisBE Date: 12/11/2006

Refreshing EWA Automatically when Sharepoint Filters are Changed

If you played around with the post on using UDFs to write to SQL databases, you probably ended up...

Author: LuisBE Date: 11/09/2006

Using UDFs to Write to SQL Databases from Excel Services

There are many reasons why writing straight to a SQL database is a desirable feature on a server....

Author: LuisBE Date: 11/09/2006

Microsoft Office 2007 Ship Party!

Last Friday was the ship party for a Office 2007. Since this was such a monumental release of...

Author: LuisBE Date: 11/06/2006

Reloading an EWA Workbook Programmatically.

This will be a quickie. I mentioned the EwaGetSessionId(id) function on my earlier post and didn't...

Author: LuisBE Date: 10/27/2006

Harvesting and Using the Session ID from EWA.

Every time you open a workbook in Excel Services you are actually creating your own instance of that...

Author: LuisBE Date: 10/27/2006

Sorry for the post hiatus.

We're getting pretty darn close to shipping and I haven't gotten much of a chance to write up some...

Author: LuisBE Date: 10/19/2006

Customizing EWA in the XLViewer.aspx Page

As you may have noticed if you have started to play around with Excel Services, the XLViewer.aspx...

Author: LuisBE Date: 10/19/2006

Consuming Sharepoint Lists in Excel Services

<UPDATE: New CS file attached with a minor bug fix and some major code reduction since I found...

Author: LuisBE Date: 09/29/2006

Impersonating EWA users in your UDFs

Excel Services UDFs are generally run under the credentials of the service account used by the...

Author: LuisBE Date: 09/29/2006

Pre-requisites

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

Author: LuisBE Date: 09/29/2006

Purpose of this Blog.

I was never big on the whole blogging thing, but I finally convinced myself once I started seeing...

Author: LuisBE Date: 09/29/2006