Welcome to MSDN Blogs Sign in | Join | Help

September 2006 - Posts

Friday, September 29, 2006 8:55 AM

Your Turn One More Time – Limits

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,
Posted by David Gainer | 25 Comments
Thursday, September 28, 2006 8:51 AM

Excel 2007 Viewer

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
Posted by David Gainer | 6 Comments
Wednesday, September 27, 2006 6:26 AM

Your Turn Again – Data Validation

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
Posted by David Gainer | 22 Comments
Tuesday, September 26, 2006 7:36 AM

Excel 2007 & Internet Explorer

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
Posted by David Gainer | 5 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
Saturday, September 23, 2006 8:39 AM

New Word Blog

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.
Posted by David Gainer | 0 Comments
Friday, September 22, 2006 5:36 AM

Another Whitepaper - Developing UDFs for Excel 2007 and Excel Services

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
Posted by David Gainer | 8 Comments
Filed under:
Thursday, September 21, 2006 6:15 AM

Your Turn - Drawing Tools

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
Posted by David Gainer | 27 Comments
Wednesday, September 20, 2006 9:09 AM

Conditional Formatting Trick 3 – The percentmin Property

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
Posted by David Gainer | 14 Comments
Tuesday, September 19, 2006 2:14 PM

Developing XLLs in Excel 2007

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.
Posted by David Gainer | 11 Comments
Filed under:
Sunday, September 17, 2006 3:04 PM

Question For The UDF Authors Out There

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
Posted by David Gainer | 13 Comments
Friday, September 15, 2006 9:35 AM

Ribbon Shots

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
Posted by David Gainer | 4 Comments
Filed under:
Thursday, September 14, 2006 1:54 PM

Updated Beta Available

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
Posted by David Gainer | 18 Comments
Tuesday, September 12, 2006 1:33 PM

Server System Requirements And A Few Other Items

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,
Posted by David Gainer | 5 Comments
Sunday, September 10, 2006 9:56 PM

Question For You All + A Bit More On Server UDFs

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
Posted by David Gainer | 16 Comments
Wednesday, September 06, 2006 11:34 PM

Hey, Where Did Solver Go?

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
Posted by David Gainer | 24 Comments
Tuesday, September 05, 2006 11:02 PM

Referencing Tables From RefEdit Controls

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
Posted by David Gainer | 14 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
 
Page view tracker