One of the advantages of having a personal blog like this one is that it gives you a space to write down stuff worth remembering that you might forget later. I have discovered that I’m usually not the only person having a problem getting something to work, and even a modest tip or trick is worth writing down. I realize that this particular issue with SAP BusinessObjects Xcelsius 2008 is old news to a lot of folks. I’ve patiently worked around the issue but finally couldn’t take it any more, as I am spending a lot of time in Microsoft Excel creating a dashboard project plan.
After installing Xcelsius 2008 (or was it one of the subsequent service or fix packs?), Excel stops opening documents properly. As you might guess, trying a Google search on common words like Xcelsius, Excel, broken, doesn’t work, etc. doesn’t return a solution quickly (does return a lot of links, though… GRIN…).
One might think that the problem is with Windows file extension associations, but the issue is corrected in Excel itself. To correct, launch Microsoft Excel, then go to Excel options, looking for the Advanced area. Look for “Ignore other applications that use Dynamic Data Exchange (DDE)” and place a check next to the item to select it. The screen shot below shows the option in Excel 2007.
Problem solved. Now back to the project plan…