MarkLogic Server (MLS) has some pretty cool plug-ins to help you work with Microsoft Office. After you configure and install the plugin, you can now have a side panel in PowerPoint populated by one of your web apps. Here’s an example of how I’ve seen this used: you’re doing some research using a MarkLogic-based search application accessed through your browser. Your project allows you to gather information into a project so you can keep the good stuff together. To finish your work, you need to produce a PowerPoint slide deck. So you use the plugin to open the project where you gathered your information right there within a PowerPoint panel. Click on some project content and it’s injected into the current slide. Pretty nifty.
The power of this capability is that the window where you are presenting content from MLS is actually a little browser window. I admit I’d be happier if they’d used WebKit or Gecko, but oddly enough, Microsoft went with Internet Explorer. Okay, well at least we have the capabilities of a browser inside of Office products, which means we can layout dynamically generated content, use AJAX, and so on.
[Update: check Pete’s comment below for a simpler solution.]
Here’s where it comes in handy that Microsoft has tied IE, Office and who knows what else so closely together — the solution turned out to be telling Internet Explorer to clear its cache. Doing so also clears the cache for the browser panel in PowerPoint, which is, after all, just an embedded Internet Explorer window.
One last thing: make sure you close PowerPoint before you clear IE’s cache, otherwise PowerPoint will hang onto the files it’s looking at.