Yesterday we were alerted to an issue in Excel 2007 (and Excel Services 2007) involving calculation of numbers around 65,535. The Excel team would like to provide a description of the issue and explain what we're doing about it. Background Yesterday evening we were alerted to an issue in Excel 2007 (and Excel Services 2007) involving calculation of numbers around 65,535. The first example that we heard about was =77.1*850, but it became clear from our testing as well as additional reports that this...

About 18 months ago, I wrote a post on keyboard shortcuts: http://blogs.msdn.com/excel/archive/2006/02/23/538311.aspx . It was a well-read post that generated a lot of comments and a lot of follow-up email. To this day, I get emails about this post, a number of which have been people asking for an XLS version of this PDF ( http://isamrad.com/dgainer/1_02-23-2006.pdf ), presumably so folks can layer their own stuff on top. Accordingly, I thought it was time for a another post on the topic. Here is...

Today’s author: Danny Khen, a program manager on the Excel team who works in the areas of programmability and business intelligence. Danny worked with a number of people, both internal and external, on the Excel 2007 XLL SDK. The Microsoft Office Excel 2007 XLL Software Development Kit is out the door at long last. Many Excel developers have been waiting for the new XLL SDK for a long time now, since we released Office 2007 at the end of last year. It took us longer than we had initially thought...

Someone (“A User”) recently sent me an email asking why comments on the blog are being disabled after a short time ... the thinking being that the short time discourages communication and community dialog. The posts are currently set to disable comments after a week. I will change that to three weeks and we can see what happens. I also received some emails recently asking about setting up trusted data connections for Excel Services deployments. There is information about that as well as a lot of...