Print this page Share

Beginning Excel Services

ISBN: 978-0-470-10489-7
432 pages
March 2007
Beginning Excel Services (0470104899) cover image


Written by Microsoft’s lead developers of Excel Services, this book shares their insights into the benefits and usage of Excel’s new server technology so that you can solve business problems. You’ll learn what Excel Services is for and how it is used, how to deploy an evaluation copy of the server and effectively administer it, and gain an understanding of how the server works. You’ll also get step-by-step guidelines for using the server in each of the scenarios for which it was designed.
See More

Table of Contents



Part I: Overview of Excel Services.

Chapter 1: Introduction to Excel Services.

Chapter 2: Getting Started with Excel Services.

Chapter 3: Architecture.

Part II: Working with Excel Services.

Chapter 4: Workbook Support.

Chapter 5: External Data.

Chapter 6: Capacity and Deployment Planning.

Chapter 7: Administration of Excel Services.

Chapter 8: Security.

Part III: How-To Scenarios.

Chapter 9: Sharing Workbooks with the Browser.

Chapter 10: Interacting with Workbooks in the Browser.

Chapter 11: Controlling Workbook Distribution.

Chapter 12: Business Intelligence Solutions.

Chapter 13: Offloading Workbook Calculation to the Server.

Chapter 14: Building Custom Solutions.

Appendix: Troubleshooting.


See More

Author Information

Liviu Asnash is a Principal Development Lead at Microsoft, and currently manages the development of Excel Services (which is part of Microsoft Office SharePoint Server 2007). Asnash has more than 15 years of experience in enterprise-level software development. In the past five years, he has worked on Microsoft Office in areas related to Business Intelligence, Excel, and Excel Services. Prior to joining Microsoft, he was the director of Research and Development at Maximal Innovative Intelligence, a software company that developed data visualization tools for Business Intelligence. Before that, he worked for six years on mission-critical server systems based on UNIX and Oracle technologies. Asnash holds a B.S. degree in Computer Science and an M.B.A. degree. He lives in Bellevue, Washington, with his wife and son.

Eran Megiddo is an entrepreneur at heart and is the Principal Group Program Manager at Microsoft, responsible for the team that defines the functionality and product road map for Excel Services. Megiddo has been designing and developing data analysis software for more than 14 years. Prior to joining Microsoft, he co-founded Maximal Innovative Intelligence, back home in Israel. Maximal developed data visualization and exploration tools that were eventually acquired by Microsoft. The tools were initially released as Microsoft Data Analyzer and are now part of Microsoft Office Excel 2007. The inspiration for Maximal was in student-assessment software developed at Memad Educational Systems, where Megiddo led the software development and product marketing efforts. He began his professional career as an officer in an elite Israeli Military Intelligence unit. Megiddo enjoys spending his free time traveling and hiking with his wife and two daughters. He is an avid theatergoer, but on most nights, you will find him in the kitchen, where he enjoys cooking for family and friends.

Craig Thomas is a Senior Test Lead who works for Microsoft in Redmond, Washington. For the Office SharePoint Server 2007 release, he is the Release Test Lead for Excel Services. He also leads a team of testers who focus primarily on server performance and reliability. Prior to joining the Office team, he was contributing to shipping Exchange Server 2003 with a focus on leading a test team responsible for the Outlook Web Access component of Exchange. Thomas discovered his technology passions later in life, after an 11-year career as a submariner in the United States Navy. He programmed with C and C++ early on, but now prefers C#, and keeps his coding skills fresh by staying involved with tools development, authoring test automation scripts, and, of course, writing custom solutions for Excel Services.

See More


Download TitleSizeDownload
Sample Sales Report Workbook 55.90 KB Click to Download
See More


Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
11 261 Chapter 11 - Steps 11 and 12 missing from page 261
11. On the Settings page, click the Permissions For This Document Library link under Permissions And Management. 12. On the Permissions page, select Add Users from the New drop-down menu on the toolbar.
See More
Back to Top