If you’re using Excel 2007 to define your BAM activities and views, you may up spending some time trying to figure out what happened to the “mark pivot table as real time aggregation (RTA)” button. It’s there, but unless you’re used to working with it, it can be a little subtle to notice. At the time this was written, the relevant documentation only shows an Office 2003 screen shot, so I thought I’d do a post.

In the toolbar, press the Add-in button, and you’ll see what’s shown below. The arrow is pointing at the RTA button, and it is pressed in this screen shot, indicating the pivot table is RTA.

And, along those same lines, if you’re not seeing the BAM add-in, then press the top-left Office button, choose “Excel options”, then and use “manage add-ins” to add it:

Technorati Tags: BizTalk,BAM,Real time aggregations,Excel 2007