Microsoft Excel

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

Setting up Excel Services to Refresh Workbooks When Opened.

Today's author, Pej Javaheri, a Product Manager on the Excel Services team, talks about one of the more common configuration questions we hear about from customers. One of the challenges in sharing Excel workbooks is ensuring that the right people see

Handling Workbook Dependencies using Excel Services

Today's author, Sanjay Kulkarni, a Program Manager on the Excel Services team. We have heard from several customers about scenarios where they have workbook dependencies. So the output of one workbook is used in other workbooks for calculations. The dependencies

Example file for PivotTable / Data Validation Trick

Recently I posted an article discussing how PivotTables can be used on Excel Services to mimick the Data Validation feature . The author, Dany Hoter, sent me a copy of the file he used in the example screen shots and I never got around to posting it for

A PivotTable Trick That Brings Data Validation to Excel Services

Today's author: Dany Hoter, a product planner who works on the Excel Services team. Excel has a feature called Data Validation that controls the possible values a user might enter into a cell or a range of cells. As you can see there are many options

Personalized Data in Excel Services

Today's author: Steve Tullis, a program manager who works on the Excel Services team. I've received a number of questions over the past months from customers wanting to deploy Excel Spreadsheets to SharePoint, such that when a user opens the page, s/he

Replacing OWC Reporting with Excel Services

Today's author: John Campbell, a program manager who works on the Excel Services teams. Replacing OWC Reporting with Excel Services As a Program Manager on the Excel Services team, I often field emails from people who have a thin reporting solution that

Integrating Excel (Services) and PowerPoint with the Microsoft SDK for Open XML Formats

Today's author: Danny Khen, a program manager who works on both the Excel and Excel Services teams. What is this about? Office 2007 introduced new default file formats – Open XML. Excel, Word and PowerPoint take advantage of them. One of the nicest things

Excel Services: Combining the EWA and API using AJAX

Today’s author: Dan Parish, a program manager on the Excel Services team. Dan is going to walk through how to enable cell editing in Excel Services using a little code. The post assumes some base knowledge of Excel Services. Today I'm going to show how,