Windows SharePoint Services 3

Useful Links:

• The official blog of the SharePoint Product Group
• Windows SharePoint Services 3.0 Technical Library
• Upgrading from Windows SharePoint Services 3.0 Beta 2 Technical Refresh to Release Version
• Nic Watters Sharepoint Services v3 (When running)

Editing Group Policy settings fails

If when editing Group Policy Object settings, you notice the settings are reverting to the previous settings - this could be because the policy is set as Read Only.

This can occur when importing group Policies from a CD Rom using Group Policy Management Console. This is because the Group Policy Object held on the CD Rom is only in Read Only format.

How to remove Read Only access to a Group Policy object

• In Group Policy Management Console, select the Group Policy Object, then on the right hand pane, select the Details tab and make a note of the Unique ID:
• In Windows Explorer browse to the domain Policies folder (i.e. c:\windows\sysvol\sysvol\FQDM\Policies)
• Right Click the Unique ID Folder then select Properties
• In the Attributes section of the General tab, remove the tick from Read Only, then click Ok
• Ensure Apply changes to this folder, subfolder and files is selected, then click Ok.

Note: The correct Read Only settings are reapplied.

MS Excel - deleting blank rows

This technique will allow you to delete all rows that have blank cells in a particular column.

1. First, before you make any drastic changes to any workbook always make sure you have a backup copy or a recently saved copy in case you need to restore the original data .
2. Now, select the cells in one column from the top of your list to the bottom.
3. Make sure that all the blank cells in this selected range are the rows you want to delete.
4. Select Edit, Goto (or press F5).
5. Click the Special button.
6. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected.
7. Now choose Edit, Delete, select the Entire Row option and click OK.

If you work with large lists of data in Excel, this tip will save you a lot of time.

Link: http://www.theexceladdict.com/tutorials.htm