September 2006 - Posts
When we started Excel 2007, we made a decision that as part of increasing the grid size, we were going to address a lot of important other “limits” in the product. The entire list can be seen here, in the second post I ever made to this blog . (Note,
Read More...
Over the past few months, I have had a number of questions about the Excel 2007 viewer – mostly, will there be an Excel 2007 viewer, and when will it be ready. (For those that are not familiar with the term “viewer”, viewers are applications that Microsoft
Read More...
The other night at home, I was doing some work at home, I ran across a situation where I wished that our “Data Validation” functionality and “Pick From List” were integrated – specifically, it would have been really nice if, after I set up Data Validation
Read More...
Today we have a guest post from Andy Tischaefer. Andy works on the Office Programmability team. Andy is going to talk a bit about a change in behaviour using Office 2007 and how you can turn the clock back if you want to. In prior versions of Office (since
Read More...
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
Read More...
The folks on the Word team have asked me to let you all know they have set up a new team blog which you can read here: http://blogs.msdn.com/microsoft_office_word/default.aspx . Check it out and follow along if you are interested.
Read More...
Danny Khen is back (Danny wrote a number of posts on programmability topics over the past year) with a white paper on developing UDFs for Excel client and server. In a few past posts, we discussed investments in user-defined functions (UDFs) in Excel
Read More...
The team that builds the drawing tools in Office (sometimes referred to as OfficeArt) is interested in understanding all the different ways people are using the OfficeArt drawing tools, images, and audio/video with Excel. While a lot of the usage is well-understood
Read More...
Folks that have been using data bars ( see here for more information) in Excel 2007 sometimes bump into a situation where the size of the bar painted by Excel on the smallest value in the dataset seems too big. An example will probably help. Take a look
Read More...
Back in January I talked about updates we have made to XLLs . We will soon be publishing an extensive article on MSDN which will cover Excel 2007 features that affect XLL add-ins and enable new XLL functionality, as well as changes to the XLL C API itself.
Read More...
Specifically, we’re interested in add-ins that create custom Function Groups (Function Groups show up in the Function Wizard, next to the built-in groups like All, Financial, Date & Time, Statistical, etc.), and add-ins that are delay-loaded. For
Read More...
OK, for those interested, here are shots of the ribbon as they shipped in the beta that was released yesterday. These are more or less finalized – there may be a few tweaks between now and when we are done, but not many. There are both XP and Vista versions
Read More...
I wanted to let everyone know a new beta of Office 2007 is now available for download and testing. (Note – you may see other sites referring to this as “B2TR” or using other similar terms. For all intents and purposes, you can think of this as the latest
Read More...
Today I wanted to cover a few topics. First, based on the response to the last blog post, I will try and put together some ribbon screenshots for those interested. Hopefully this week. I might not get to XP and Vista, but I will do what I can. Second,
Read More...
A few months ago, I mentioned that around the time we fully locked down the user interface in preparation for shipping, I would post a series of blogs that featured the final ribbons for Excel 2007. It occurred to me today, however, that the public beta
Read More...
To this point in the blog, I've covered most of the new features that we've added to Excel 2007, but I wanted to quickly mention a couple of tools that folks use in Excel and where they can be found in Excel 2007 – specifically, the Solver and the Analysis
Read More...
SamRad is back with another guest post. Today Sam is writing about another feature he worked on - supporting table referencing from places other than the formula bar. Enjoy. Dave posted about Tables and the new "structure referencing" feature in previous
Read More...
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
Read More...
