Change SharePoint Designer Workflow task list

When creating a SharePoint Designer 2007 workflow, the workflow uses the first task list available, based on the name of the task list, sorted alphabetically.

2 ways to use a specific task list for your workflow:

•   create a new task list with a name which makes the new task list the "first" task list available. After the workflow is associated with this new task list, then you can go ahead rename the task list to your liking.
• modify the *.wfconfig.xml in SharePoint Designer. Specifically, change the TaskListID to the tasklist id of the task list you want the workflow to use.

SetState activity fails using one of the predefined SPWorkflowStatus enumeration values

Get the following error message: System.ArgumentOutOfRangeException: Specified argument was out of the range of valid values.     at Microsoft.SharePoint.Workflow.SPWorkflow.SetIStatus(Int32 i, Int32 iStatus)

Workaround: use custom values, see below:

<ExtendedStatusColumnValues>
<StatusColumnValue>CustomStatusStatusColumnValue>
ExtendedStatusColumnValues>

SharePoint 2010 can't open xlsx file in the browser

Received message "Unable to process the request. Wait a few minutes and try performing this operation again".

Fix:
1. Ensure that Excel Service Application is created and running under "Manage service applications"
2. Ensure that Under "Manage services on server", the Excel Calculation Services is started and running on the web front end(s) of the farm
3. Ensure that the Excel Service Application is associated with the proper web applications under "Configure service application associations"

Update: Excel file can't be edited in browser without Office Web Apps. 

How to change the namespace of safecontrol entry for a visual webpart

Here it is: basically you need to make the change in SharePointProjectItem.spdata which is located at the same folder as your webpart code.


I found the solution from this blog: http://pholpar.wordpress.com/2010/03/10/changing-the-namespace-of-the-web-part-in-a-visual-web-part-project/

SharePoint 2010: Clicking the icon in Type column is highlighting the item instead of launching the document

Symptom:

In a list view of a document library in SharePoint 2010, when the document icon for an item in the Type column is clicked, the document is not offered for opening. Instead, the row for the item is selected. This behavior is different from SharePoint 2007 where clicking on the document icon opens the document itself.

Fix: http://support.microsoft.com/default.aspx?scid=kb;en-US;2457975

How to remove "Edit in sharePoint Designer" from Site Actions menu

Suggested by this thread: http://social.msdn.microsoft.com/Forums/en-US/sharepoint2010general/thread/46c9b89b-bec8-4335-9096-d7bf7a8114f4/

Hide Edit in SharePoint Designer:

• In Central Administration you can disable SharePoint Designer at the Web application level - Manage Web Applications > Select your web app > In the ribbon click on the General Settings Dropdown > Select SharePoint Designer. When the settings page appears, deselect the "Enable SharePoint Designer" checkbox then click OK. You'll obviously need Central Admin access to use this method.
• At the site collection level, in Site Collections Administration section of "Site Actions > Site Settings" at the site root, click on the "SharePoint Designer Settings" link. Same options as Central Admin appear - Uncheck the "Enable SharePoint Designer" checkbox then click Ok. You'll need to be a Site Collection Administrator to use this method.
• Note - Site Collection administrators will always be able to edit in SharePoint Designer 

Above does not work, after I made above suggested changed in CA, the option is still available. However, the capability of editing in SharePoint Designer is disabled.

Upload Multiple Documents Option in SharePoint 2010 is missing

This will occur if a client machine is using 64bit Internet Explorer per the following thread:

http://social.technet.microsoft.com/Forums/en-US/sharepointadmin/thread/38a04376-917f-4493-9f03-0b3229991a21/

Slow SharePoint (MOSS 2007) Windows Explorer View using Windows 7 and Internet Explorer 8 (IE8)

Here is the fix:

1. In IE8, go to Tools > Internet Options
2. Click the Connections tab, then the LAN Settings button
3. If Automatically detect settings is checked, uncheck it
4. Reboot

This solution is original posted by Blind Hole.