Microsoft Excel

Quick and Easy Data Access with Excel Services

Today’s author, John Campbell, a Program Manager on the Excel Services team, shows us the quick and easy way to get external data access working with your Excel Services spreadsheets. I have seen a lot of great blog posts that tell folks how to do great

New Case Study Involving Excel Services

A new case study has been published that describes how Microsoft IT used Excel Services to build a portal for finance data. Here's a snippet from TechNet: Controller Workspace: Connecting With Excel Services in Microsoft Office SharePoint Server 2007

Understanding Excel Services Load Balancing Options

Today's author, Steve Tullis, a Program Manager on the Excel Services team, talks about the various load balancing schemes available for Excel Services. I have received a number of questions in the past few weeks about the load balancer administration

Excel Web Application Announced at PDC

During today’s Professional Development Conference keynote, Ray Ozzie made an exciting announcement about a new way to view, edit, and collaborate with Excel. If you weren’t able to watch the keynote, feel free to check out the following links: PDC Keynote

Using Office Data Connection files (.odc) and the DataConnections Web Part in SharePoint to Specify External Data Connections in Newly Created Excel Workbooks.

Today's author, Christian Stich, a Program Manager on the Excel Services team, discusses how to enable users to quickly and easily create workbooks using external data connections specified in server based data connection files. Overview Excel and Excel

New Online Training Courses for Excel Services

We just recently released some online training courses for Excel Services and I wanted to call your attention to them. Excel Services I: The Basics - An overview of the value proposition of Excel Services as well as the basics for publishing and sharing

Using Excel & Excel Services with SQL Server Analysis Services 2008

Today's author, Pej Javaheri, a Product Manager on the SharePoint team, talks about configuring Excel Services to work with the just-released SQL Server 2008. With the recent announcement of SharePoint Server 2007 supporting SQL Server 2008 , like you,

Building an Asset Tracking Application in Excel Services – Part 5 of 5

Today's author, Dan Parish, concludes his discussion of building an Excel Services solution. In Part 4 , I walked through creating the web part pages for the solution. At this point, you should have a fully functional asset tracking application up and

Building an Asset Tracking Application in Excel Services – Part 4 of 5

Today's author, Dan Parish, continues on his discussion of building an Excel Services solution. In Part 3b I walked through creating a User Defined Function (UDF) that pulls information from a SharePoint List into Excel Services. In today's post, I will

Building an Asset Tracking Application in Excel Services – Part 3b of 5

Today's author, Dan Parish, continues his discussion on building an Excel Services solution. In Part 3a I walked through how to create the SharePoint List that stores the data users enter. In this post, I will walk through how to create the Excel Services

Building an Asset Tracking Application in Excel Services – Part 3a of 5

Today's author, Dan Parish, continues his discussion on building an Excel Services solution. Part 3 turned out to be a bit longer than we had anticipated so we've split it up into two parts: 3a and 3b. Thus far in this series, I have given an overview

Building an Asset Tracking Application in Excel Services – Part 2 of 5

Today's author, Dan Parish, a Program Manager on the Excel Services team, continues on with his multi-part post about building an application using Excel Services. In my last post I gave an overview of the asset tracking application that I am going to

Building an Asset Tracking Application in Excel Services – Part 1 of 5

Today's author, Dan Parish, a Program Manager on the Excel Services team, will discuss over the next few posts how he built an asset tracking application using Excel Services. At the SharePoint Conference in Seattle in March, I did a presentation entitled

Ten Tips for Using Excel Services

A new MSDN article about Excel Services was just released. If you do any kind of work with Excel Services, whether you are just getting started with it or trying to do something a bit more advanced, this article is a pretty good read because it covers

New Technical Article on Excel Services

There's a new article up on MSDN that describes a custom solution built by the IT department here at Microsoft that uses Excel Services. Rather than re-paraphrase, I'll "borrow" liberally from Shahar's description : The solution is probably one of the