Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Excel Server   (RSS)
Monday, March 24, 2008 4:11 PM

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
Posted by Joseph Chirilov | 3 Comments
Wednesday, March 05, 2008 12:45 AM

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
Posted by Joseph Chirilov | 3 Comments
Attachment(s): WorkbookDependencies.zip
Tuesday, March 04, 2008 6:48 PM

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
Posted by Joseph Chirilov | 3 Comments
Wednesday, February 13, 2008 12:50 AM

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
Posted by Joseph Chirilov | 17 Comments
Wednesday, January 16, 2008 7:54 PM

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
Posted by Joseph Chirilov | 7 Comments
Filed under: ,
Wednesday, January 09, 2008 1:13 PM

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
Posted by David Gainer | 19 Comments
Monday, December 24, 2007 6:01 AM

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
Posted by David Gainer | 11 Comments
Monday, October 29, 2007 3:47 PM

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,
Posted by David Gainer | 8 Comments
Filed under:
Wednesday, September 05, 2007 12:41 PM

Comments and Server Docs

Someone (“A User”) recently sent me an email asking why comments on the blog are being disabled after a short time ... the thinking being that the short time discourages communication and community dialog. The posts are currently set to disable comments
Posted by David Gainer | 2 Comments
Filed under:
Tuesday, August 28, 2007 9:50 AM

Excel Services Books

Today’s author: Eran Megiddo, the program manager who led the Excel Services 2007 effort. Eran is going to briefly talk about a few books that the Excel Services team wrote about the product. I wanted to let folks know about two new Excel Services books
Posted by David Gainer | 1 Comments
Tuesday, August 14, 2007 8:02 PM

Christian Stich on Excel Services: Financial option valuation implemented with Monte Carlo simulation using multithreaded User Defined Functions (UDFs)

Today’s author: Christian Stich, a program manager on the Excel Services team who likes to combine his finance and engineering backgrounds. Christian is going to talk about building a multithreaded UDF for Monte Carlo simulations and using it for options
Posted by David Gainer | 8 Comments
Friday, December 22, 2006 11:24 AM

More MSDN Content That May Be Useful

I have been getting a lot of Excel Services questions lately (along with a bunch on setting up Analysis Services to work with Excel 2007 and a raft on conditional formatting), so I thought I would point out some Excel Services documentation that is now
Posted by David Gainer | 4 Comments
Filed under:
Sunday, December 03, 2006 11:20 PM

Whitepaper - External Data Connections For Excel Services

From the Excel Services team: "We all know there are plenty of stumbling blocks that customers hit along the way in getting external data access configured for the first time. Some of you may have seen me shopping around a whitepaper that provides some
Posted by David Gainer | 2 Comments
Filed under:
Monday, September 25, 2006 11:30 AM

Using Parameters In Dashboards

Today we have a guest post from Dan Parish, who is a program manager on the Excel Services team. Dan is going to explain a bit more on how to use Excel Services to set up dashboards that are driven by parameters. Back in the original posts regarding Excel
Posted by David Gainer | 3 Comments
Friday, September 01, 2006 9:00 AM

Making Excel Services UDFs Work in Excel 2007

Shahar Prish, one of the developers on the Excel Services team, has recently posted a few entries on his blog that explain how to make Excel Services UDFs work in Excel 2007. (UDF stands for “user defined function”, which refers to custom functions that
Posted by David Gainer | 0 Comments
More Posts Next page »
 
Page view tracker