Windows 7 & Office Web Components (OWC)

OWC Pivot Tables is broken in Windows 7 due to two things. UAC and MSOLAP.

Symptoms include pivots with no data in them. The fix is pretty easy. Turn UAC off and install MSOLAP 3. Windows 7 ships with MSOLAP 2 and MSOLAP 4 but not MSOLAP 3. Test your application to see if it works. If it does work, turn UAC back on, you should not run with UAC off. To fix the UAC issue, you’ll need to go to the Microsoft site to get the proper shim. Or, configure Windows 7 to whitelist the application for UAC.

 

Leave a Reply

Your email address will not be published. Required fields are marked *