Office Zealot

Microsoft is making some great progress with its SQL Server 2008 Data Services initiative. The latest addition to the line-up of data services available online is data mining! You can access the beta version of the data mining tools in the cloud by visiting http://sqlserverdatamining.com/cloud/. At this website, you have 2 options for trying out ...

Today I received a copy of the new book from Robert Martin, Ken Puls, Teresa Hennig on customizing the Office 2007 Ribbon. What else could the title of the book be: RibbonX: Customizing the Office 2007 Ribbon. First impression is that it is an excellent book for everyone who wants to know all about how to handle your RibbonX works for Excel, ...

As a software developer working in a particular software one tends to think only of solutions within that technology – within that box.  Makes sense to me. But today I found that thinking outside the box is sometimes necessary to solve technology problems in ways that are almost impossible to imagine when your gaze is focused too tightly on ...

The toughest things about doing custom development in Office is the fact that the more distributed the application gets the more likely it is that some obscure localization or setting will bite you in the backside.    I live and do most of my business in English Canada, within Fortress North America.  Thanks to living next door ...

  You can now download fixes for the Excel bug that was in all the media a few weeks ago. The bug showed an incorrect answer in calculations, presenting 100,000 instead of 65,535. Microsoft published a couple of fixes for Excel en the Excel Services. In the end the fixes are planned to be added to Office SP1. The releasedate ...

LEAD Technologies Inc. V1.01

Take one cup Google Docs, one cup Microsoft Excel and add a dash of programming. Observe.

Question: When does 850 * 77.1 not equal 65,535? Answer: When you're using Excel 2007. A bug in Excel 2007 (and Excel Services) is causing issues around calculated values of 65,535 and 65,536. Calculations that evaluate to the values may incorrectly display 100,000 as the result (although internally, Excel stores the value as the ...

I was more than a little bummed yesterday (annoyed is more like it) when I found out why I was missing the Excel Services option on the Publish menu in Excel. Excel 2007 Enterprise Publish Menu Little did I realize that all of the work I’ve been doing to date inside a Virtual PC image used Office Enterprise edition. I didn’t even think twice ...