This is the reason why I haven't been updating my blog lately. We have been heads-down making sure we delivery an incredible user experience in our next release: http://www.microsoft.com/presspass/press/2009/jul09/07-13Office2010WPCPR.mspx http...

I have been extremely busy lately and haven't been able to update this blog as much as I would like. However, I have been speaking with many of you frequently over the email. I'm glad I was able to help most of you out. Please keep the questions coming...

Clients have recently asked questions about Saving workbooks back to the server. In Excel Services, there are several ways to save back to the server. However, the two simplest ways to do it are: Open in Excel (or Snapshot) using the Client, modify...

Let me begin by explaining the two concepts first. When you load a workbook on Excel Services, you are given two options to open the workbook on Excel. Snapshot : This provides users a copy of the workbook with all the formulas behind the numbers...

One of the most impressive controls that Excel Services offers its spreadsheet owners is the ability to limit which parts of the workbook are accessible through the server (IE, sharepoint, API, etc). This is an incredibly powerful ability, especially...

By now, most of you have probably encountered the following common error while attempting to load legacy Excel workbooks (*.xls). If you didn't, you must have read-up extensively on MSDN. (Congrats to you!) File Format Well, the reason why this...

For anyone who is interested in learning more about Excel Services, this is one of my favorite books (not only because it's written by my colleagues): I highly recommend reading this one!

Excel Services is an enterprise-class application server that is geared towards performance, scalability, and security. Trusted Locations is one of the many excellent example of how Excel Services offer security when managing access to workbooks on the...

I had an interesting discussion over lunch yesterday. Someone asked me to explain to them what Stored Procedures are and how their businesses could benefit from using them. Firstly, let me start by saying that I love Stored Procedures (sprocs). I developed...

I have recently received countless request on providing more information regarding Excel Services installation on a Server Machine (Windows 2003). In this blog post, I will outline a quick overview of a Standalone installation for both 32 bits and 64...

Excel Services is a brand new server technology that enables you to Load, Calculate, and Display Excel workbooks on an Office SharePoint Server. Excel Services is currently released with Microsoft Office SharePoint Server 2007. There are essentially...

In a capsule, ASP 3.0 or ASP.NET is a server scripting language that enables programmers to generate HTML or JavaScript code. Since it is server side, clients will not be able to view the server side script by simply using "View Source". As you probably...

I guess let me start by saying something about myself before I start rambling about all the cool stuff in Excel. My name is Sherman. I'm a Software Design Engineer in Test (SDET) in the Microsoft Excel Team ; a team that I am very proud to be part of...