Tuesday 23 November 2010

Unable to view SharePoint list in Datasheet with Office 2010

I just found that I am unable to view a SharePoint list in Datasheet view because I have the 64bit version of Office 2010 installed.

The error message is :

The list cannot be displayed in Datasheet view for one or more of the following reasons:
A datasheet component compatible with Microsoft SharePoint Foundation is not installed.
Your Web browser does not support ActiveX controls.
A component is not properly configured for 32-bit or 64-bit support.

To fix this follow this link to Microsofts Knowledge base article http://support.microsoft.com/kb/2266203

Wednesday 6 October 2010

Show Quick Launch on SharePoint 2010 Webpart Page

When you create a webpart page on SharePoint 2010 or 2007 for that matter, the quick launch will vanish.

With SharePoint 2007 all you needed to do was edit the page in SharePoint Designer and remove the following 2 lines:

< asp:Content ContentPlaceHolderId="PlaceHolderNavSpacer" runat="server"></asp:Content>
< asp:Content ContentPlaceHolderId="PlaceHolderLeftNavBar" runat="server"></asp:Content>

With SharePoint 2010 you also need to delete the following:

< style type="text/css">
body #s4-leftpanel {
display:none;
}
.s4-ca {
margin-left:0px;
}
</style>

The quick launch will now display on the web part page.