Sharepoint 2007 Change colour of Site Actions menu

Standard

This one below I need to log somewhere as it took me a while to find this class.
I was trying to change the background colour when hover the Site Actions drop down menu in Sharepoint 2007. In fact it’s the same colour on all drop down menus, site actions, action buttons, etc..





Here is the class in CSS :

  .ms-MenuUIItemTableHover {
      background-color: #f1f1f1 !important;  /* Roll-over on sub-menus and all drop down menus*/
      border: 1px #7BA8CE solid; 
}

Continue to sync a Sharepoint list with Excel 2007

Standard

As you used to do with Excel 2003.

 

I just stumble upon this add-in, so forgive me if I am a bit late ;-) (just 2 years)

 

Synchronising a list with Excel 2003 is very easy out of the box,

but this functionality has been removed in 2007.

An Excel 2007 table can be published but any changes on either Sharepoint or Excel will not be sync in the future.

 

This.. until Microsoft released this add-in (certainly after thousands of users complained of the loss of functionality).

http://www.microsoft.com/downloads/details.aspx?FamilyID=25836e52-1892-4e17-ac08-5df13cfc5295&DisplayLang=en

 

If your users are on Excel 2007, it may be a must-install plug-in.

Off bug : Export a MOSS2007 list to Excel 2003 error – now fixed

Standard

Found the answer in a post on EggHeadCafe.com.
the problem was a column Date/Time format that must have got corrupted, once I change the type one by one to TEXT it then exports OK, and the type can be changed again to Date/Time and exported fine.
Don’t we love these kind of bugs.. grrr….
Is there a KB article for this ?

Sharepoint general Cannot get the list schema column property from the SharePoint list: “Cannot get the list schema column property from the SharePoint list”