June 2006 - Posts
One of our team members recently noticed an issue with Excel VBA code running on Windows Vista (it is something that happens on WindowsXP too, it is just more pronounced on Windows Vista), so I thought I would write it up. While it is not the sort of
Read More...
A while ago, I wrote a post about 214 keyboard shortcuts . In the last few months, we have added 4 more for one reason or another, so I wanted to pass them on. (I have not updated the matrix I included as part of that post, because I accidently misplaced
Read More...
Fairly recently, the Microsoft Windows Compute Cluster Server 2003 team publically released their product. What is “Windows Compute Cluster Server”? Lots of information available here , but, to borrow a line from their site, Microsoft Windows Compute
Read More...
Over the next week or so, I am taking some time off to head back home with my family. I have set up some content that, with any luck, will get auto published while I am gone, so there should be stuff to read. That said, I wont be around to reply to comments
Read More...
A few months back I wrote several posts about the improvements that we made to PivotTables in Excel 2007. I even showed how summarizing data in different ways is now just a right click away on the “Summarize Data By...” menu. What I didn’t show was that
Read More...
Today we have the second of two guest posts from Patrick Smith, a program manager on the Office Programmability team. Overview and Background Managed code is becoming more and more prevalent in add-ins written for Microsoft Office products. Also shipping
Read More...
One of the topics I was going to cover at some point was the "command well", which is the list of commands in the various Office products. You can use this list to add or remove things from the "Quick Access Toolbar". For example, for those of you that
Read More...
Today we have the first of two guest posts from Patrick Smith, a program manager on the Office Programmability team. Writing managed code against the 2007 Microsoft Office System products requires the use of an interop assembly. Just as we did with Microsoft
Read More...
Greetings – since I was in absentia for more than a week, comments are shut off for recent posts. Accordingly, I am going to reply here to the last round of comments here. For those of you that suggested new topics, I have written them down, and will
Read More...
Over the next few days, I am on a ridiculously over-scheduled training course, so I will not be producing any new content until sometime mid next week (and probably not answering comments or emails until then too). In the meantime, I wanted to ask you
Read More...
Every release, part of what the team (and the entire company) does when working on a new release of Excel is use it in all sorts of ways (often referred to as “dogfooding”). We use it in our daily work, we build solutions that the team uses to manage
Read More...
Last week, in response to my post on charting, Harlan pointed at a few Economist charts as examples of professional charts. Today, I spent a few minutes with Excel 2007 trying to create a similar chart. I thought I would share the results. The chart in
Read More...
Over the past few months, when I have posted information about charting in Office 2007, there has been plenty of feedback and discussion about the work presented. Today, I wanted to spend a bit of time addressing some of that feedback. When I read over
Read More...
A few months back, I wrote a post about how Excel 2007 will enable customers to save their work as a PDF file by simply using the Save As command from within Excel. Well, it turns out that’s not looking like it will be the case – the feature will be available
Read More...
