Browse by Tags
Today’s author is Bill Seddon from Lyquidity Solutions, who informs us about a free tool for Excel users that allows you to find combinations of numbers that total to a selected value. For more information and a video, see http://www.lyquidity.com/findcombinations
Read More...
Thanks to Dan Parish for putting together this post. One of the great things about Excel Services is the Excel Web Access (EWA) web part. This web part allows you to render entire workbooks, or just portions of a workbook (for example a chart or a Table)
Read More...
One of our most senior developers on Excel Services, Shahar Prish, is busy writing posts in his blog on the new programmability features in the 2010 version of Excel Services. The first set of posts talk about REST and moving forward he will expand to
Read More...
Thanks to Christian Stich for putting together this series on the REST API. In this final installment on the REST API, we’ll walk through a couple examples of using the REST API to embed spreadsheet data in new and interesting ways. Embedding a ‘Live’
Read More...
Thanks to Christian Stich for putting together this series on the REST API. As we saw in the previous post , using the Excel Services REST API is as simple as specifying a URI (Uniform Resource Identifier) in your web browser. In this post we’ll walk
Read More...
Thanks to Christian Stich for putting together this series on the REST API. Beginning our journey on all things Excel Services 2010, I thought I’d start off with a feature that’s been getting a lot of buzz lately since its introduction at the SharePoint
Read More...
Thanks to Steve Tullis for putting together this post. Before delving into Excel Services 2010, I want to recap a point that some readers may not be aware of. The Excel team is delivering two browser-based solutions as part of the Office 2010 wave of
Read More...
Overview In Excel 2007, the ability to directly resize or reposition points on the chart was deprecated. This feature was sometimes referred to as "Graphical Goal Seek." For example, in Excel 2003 a user could click on a data point in a column chart twice
Read More...
MICROSOFT SOFTWARE LICENSE TERMS MICROSOFT EXCEL ADD-IN FOR MANIPULATING POINTS ON CHARTS NONE These license terms are an agreement between Microsoft Corporation (or based on where you live, one of its affiliates) and you. Please read them. They apply
Read More...
This article continues the series on PowerPivot that started with an overview as well as an introduction to PowerPivot for Excel 2010. We’ll now focus on the support PowerPivot provides for collaboration. Frequently, business users need to share applications
Read More...
In this blog article, we’ll step through using PowerPivot for Excel 2010 for building a rich application in Excel. Note: following screenshots describe the SQL Server 2008 R2 August Community Technology Preview (CTP) functionality for a feature codenamed
Read More...
More info and a fun video here: http://powerpivot.com/
Read More...
Today we have a guest author from the SQL Server Analysis Services team, Ashvini Sharma, to tell us about the PowerPivot (née Gemini) feature that you may have heard about recently. PowerPivot is the recently announced name of technologies this blog previously
Read More...
Today at the SharePoint conference the Office Developer Marketing Team announced the Office 2010 Application Compatibility Program . Details were posted today at Gray Knowlton's blog . Here's an excerpt from his post: With the great value Office 2010
Read More...
I know many Excel users also tend to be Access users, so I thought it would be a good idea to share this bit of news. The Access folks recently recorded a great video showcasing the major work that has gone into Access 2010. In short: Access solutions,
Read More...