Excel Services Calculation Issue Update & Fix!

Please check out David’s post for links to the fixes. http://blogs.msdn.com/excel/archive/2007/10/09/calculation-issue-update-fix-available.aspx


Calculation Issue Post on Excel Blog

This same calculation issue affects Excel Services, and is being addressed concurrently. http://blogs.msdn.com/excel/archive/2007/09/25/calculation-issue-update.aspx


Sponsor me for JDRF’s Beat the Bridge!

Dear Friends and Family, I recently accepted the challenge to raise funds to support the JDRF Northwest – Nordstrom Beat the Bridge in its efforts to find a cure for diabetes and it’s deadly complications.  Every day 35 more children are diagnosed with diabetes. This diagnosis means a lifetime of insulin shots and extremely devastating complications, not…


Excel Services Team Looking for Customer Connections!

The Excel services team is looking for companies that are using Excel services and are willing to share their feedback with the team.   Feedback can be in the form of visits to the customer sites, conference calls or special events that will be organized in Redmond or in Europe.   If you are interested…

New blog from an Excel Services Tester

Another one of our prolific Excel Services testers has started up a blog here: http://blogs.msdn.com/sherder/  Go check it out!     I’ve been a little dark on the blog lately in order to focus 100% on planning for O14, but I’ll be back soon!  

Microsoft Office is Searching for Talented Devs!

Microsoft Office is looking for talented developers to work on cutting edge web-based technologies that integrate with Excel and Access. It’s a great opportunity to work on cool new features and build great products.  You may have already heard about Excel Services that we shipped with Office 2007 (if not you can read more here…

Excel Services step-by-step guides

Technet now has some interesting tutorials for Excel Services.  Check them out at http://technet2.microsoft.com/Office/en-us/library/eea3ace8-0863-429a-b1e8-041254ed2fc41033.mspx?mfr=true Enjoy!


New MSDN Article on Extending Excel Services Through UDFs

From yours truly: Summary: Optimize version 1 of the Excel Services programmability framework to extend Microsoft Office Excel 2007 and Excel Services functionalities to work with SharePoint lists, query tables on Excel Services, external workbook references, SQL write-back, and user-defined functions (UDFs).   Link: http://msdn2.microsoft.com/en-us/library/bb267252.aspx   NOTE: I already caught a few mistakes that the…


Enable Paging in Your Array Formula UDFs

As I alluded to earlier, one way to overcome the limitation that array formulas do not dynamically resize to fit the dimensionality of the data being returned by your UDF is to use paging. Here is a simple way of enabling paging, without having to modify any existing UDF code (you could also use this…

Consuming Business Data Catalog Entities in Excel Services

One of the coolest (only?) SharePoint external data features is the Business Data Catalog (BDC). The BDC is brand new with SharePoint 2007, and is not yet fully integrated into Excel and Excel Services… though, if you’ve read one or two other entries in this blog you’ve probably figured out where I’m going with this…