I've just started seeing this too - clearcontents hangs Excel, but only with large ranges. Did removing the security update work? Restoring the system to a previous date did nothing.
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com