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

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

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...

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...

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 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...

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!

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...

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...

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...

Here are a few books being worked on about Excel Services: http://www.amazon.com/Beginning-Excel-Services-Liviu-Asnash/dp/0470104899/sr=8-1/qid=1168539718/ref=sr_1_1/105-2258527-0791610?ie=UTF8&s=books http://www.amazon.com/Professional-Excel...

MSDN has created a forum for Excel Services related discussion, you can find it at: http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=1208&SiteID=1 We're working on a more readable shortcut, and it's empty as of right now but you can expect...

<UPDATE: Reworded the post to stay away from any legal issues :o) > We are currently working on planning for the next version of Excel Services and I would greatly appreciate any v1 feedback as well as requests you would like to see implemented...

As you have noticed, many of my samples below use an Array Formula in Excel to retrieve an array of data returned by your UDF code. The biggest issue with taking this approach is that you need to know ahead of time the exact dimensions of the data...

As you may or may not know by now, one of the limitations in this version of Excel Services is the inability to publish workbooks containing Query Tables (tables that have external data as their source). There have been numerous blog posts on the web...

If you played around with the post on using UDFs to write to SQL databases, you probably ended up creating a PivotTable connected to the SQL database the UDFs were writing to in order to see the new data showing up on the database. As you would have...

There are many reasons why writing straight to a SQL database is a desirable feature on a server. For example, one could imagine a solution where users would load up a workbook on Excel Services, change some parameters, and have that new data saved to...

Last Friday was the ship party for a Office 2007. Since this was such a monumental release of Office, the ship party had to live up to the years of hard work this release required... and it did. First was the party itself, outdoors in the Microsoft...

This will be a quickie. I mentioned the EwaGetSessionId(id) function on my earlier post and didn't want to forget the other useful Javascript function we're shipping in the EwrScripts.js file. With a simple Javascript function call you can trigger...

Every time you open a workbook in Excel Services you are actually creating your own instance of that workbook. Excel Services keeps track of those instances by assigning them a text string called a session ID. Once a session is created you can perform...

We're getting pretty darn close to shipping and I haven't gotten much of a chance to write up some of the posts I have been meaning to. Hopefully things will slow down soon enough so I can get to them. I'm planning on posting on the following solutions...

As you may have noticed if you have started to play around with Excel Services, the XLViewer.aspx page is the leanest way to open up a workbook on the server. There is very little Sharepoint UI added to this page and you are basically given a full screen...

<UPDATE: New CS file attached with a minor bug fix and some major code reduction since I found the SharePoint format converter method :o) > There are a few features that the v1 of Excel Services will not support out of the box. One of these is...

Excel Services UDFs are generally run under the credentials of the service account used by the Office Server installation. This may not be exactly what you want if you would like your UDFs to return data that is specific to the user that opened the workbook...

Instead of re-hashing information I've found elsewhere I figured a pre-reqs post would be good. One of our Devs in Excel Services has done a great job with posts on Excel Services User Defined Functions (UDFs) and programmability in general. I use...