SharePoint datasheet view suddenly stopped working

WSS Datasheet View banner

While working in datasheet view in a SharePoint document library (WSS 3/XP Professional/IE7) and switching back and forth between different views, the datasheet view suddenly stopped working and displayed an error dialog saying :

“The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Windows SharePoint Services is not installed, your browser does not support ActiveX controls, or support for ActiveX controls is disabled.”

Luckily, I found a post that suggested to delete your cache to solve the problem. Did it (had to close the browser and log back into my SharePoint) and it worked! Here’s the original blog link:

http://geekswithblogs.net/paullee/archive/2009/05/01/sharepoint-datasheet-view-errors.aspx