Found many posts on the internet but none adressing this scenario:

The machine has Office 2010 64bit, which means that "2007 Office System Driver: Data Connectivity Components" had to be installed in order to work with SharePoint Datasheet View:


But then there is this problem with lookup columns on a list pointing to calculated columns on other list that every value on the field will start with "string;#" followed by the actual values on tha calculated column.

This is a known bug for which there is this hotfix:


Problem is the hotfix does not apply for people with just the Data connectivity components referred above.

Anyone knows of some other fix, or will I have to workaround with a workflow/event handler?

1 Answer 1


After much looking around got to the conclusion that no fix matches this situation and a workaround should be applied.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.