Tag Archives: Office

Unable to check-in document after check-out

Problem

One of our users had a problem opening an excel document in Excel 2007/ When she clicked on ‘Open in Excel’ followed by ‘Edit and Checkout, using local drafts folder’, excel would open the document but she would not be able to check it back in. Excel would prompt her that a local copy is already checked out. If she continued, she would be prompted to save a copy of the file in a temp folder.

Forcing SharePoint not to use the local drafts folder resulted in an error  – unable to convert file.

Solution

In the end, what I ended up doing was running a repair on her Office installation.

Open Excel -> Excel Options -> Resources -> Diagnose

Restart IE and excel once you have run the diagnostic wizard and everything should go back to normal.

Comments ( 0 )

Workflow initiation form postback error

Problem

I am creating a customized version of the OOTB ‘Approval – SharePoint 2010’ workflow. What I did was basically select the Global Reusable workflow and made a copy of it. The workflow publishes without any problems. However, when I try to add the workflow to a SharePoint list and nominate an approver, I get the following error:

The following error gets logged in the event log:

There was a form postback error. (User: domain\andrew.toh, Form Name: Template, IP: , Request: http://sharepoint/_layouts/CstWrkflIP.aspx?List={7E380371-9012-4582-934E-79A47AE75A5E}, Form ID: urn:schemas-microsoft-com:office:infopath:workflowInitAssoc:-AutoGen-2012-07-20T00:41:31:452Z, Type: SchemaValidationException, Exception Message: Schema validation found non-datatype errors.)

ULS Logs

SharePoint Foundation Web Controls Medium Failed to get SPGroupName from GroupID. Error Message: Group cannot be found.  Callstack:    at Microsoft.SharePoint.SPGroupCollection.GetByID(Int32 id)     at Microsoft.SharePoint.WebControls.PeopleEditor.set_SharePointGroupID(Int32 value).

Solution

To work-around this problem, I had to install SharePoint Designer 64 bit, re-copy the OOTB workflows, modify them, and re-publish.

Comments ( 0 )

Office 2010 64bit has no datasheet view

Problem

You try to access datasheet view in a SharePoint list and get the following error:

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.

Cause

Office 2010 64bit does not support data sheet view.

Resolution

Downnload the 2007 Office System Driver : Data Connectivity Components

http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734

Comments ( 0 )

Cannot view list in Datasheet View

Problem

Ran into an interesting issue this morning. I recently had to install Office 2010 64bit on my computer to work with some extremely large Excel spreadsheets. I noticed today that when I tried to open one of the SharePoint list in datasheet view, it came up with the following error:

The list 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

Cause

This is a known compatibility issue between Office 2010 64bit and SharePoint. Microsoft has a workaround for this issue.

Solution

Install KB2266203 from Microsoft.

http://support.microsoft.com/kb/2266203

After installing the fix, the problem was resolved immediately.

 

Comments ( 0 )