XML in Office 2007

Open XML Format SDK 2.0
Online version: Open XML Format SDK 2.0
XML in Office Developer Portal

2007 Office Resource Kit Technical Library in Compiled Help format

This downloadable CHM file (3.5mb) is a copy of content in the 2007 Office Resource Kit technical library. The CHM is current as of 29 August 2009.

Neat Office Toolbar Tricks

There is always something you can learn about MS Office. In a post today on her Tech Republic blog, Susan Harkins reveals two really neat tricks to quickly copy or move a toolbar button in any Office 97 to Office 2003 application

New Excel Chart Wizard

Microsoft Office Labs has developed the Chart Advisor: a prototype add-in that provides an alternate approach for creating charts in Excel 2007 and uses an advanced rules engine to scan your data and, based on predefined rules, displays charts according to score.

Top scoring charts are generated charts, ranked, and displayed as thumbnails in a dialog for preview and tweaking by filtering data and how it is mapped.

I have asked for an Access version.

Using Access and Excel Together

The MS portal, Office Online, has posted a substantial article on using Access and Excel together to manage data solutions: Top 10 reasons to use Access with Excel. This is the introduction to the article:

When using the Office family of products, should you use Excel or should you use Access to manage your tabular data? A companion article, Using Access or Excel to manage your data, recently discussed the benefits of each product and what they "bring to the table". But why choose between one or another? If you store your data in Access and connect to it from Excel, you gain the benefits of both. Here are ten reasons why a marriage between Excel and Access makes lots of sense. Excel users, don't be afraid to let go of your data. Think of it this way. You're not losing an Excel daughter; you're gaining an Access son-in-law.