When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items. I found this hotfix, but it did not apply. http://support.microsoft.com/kb/948952 Any ideas how to get this resolved?

Hello, How come the hotfix didn't apply? Are you running Office 2007 on your machine? If so what did it say when you tried to install it? Thanks, -AseemThis posting is provided "AS IS" with no warranties, and confers no rights

Is your lookup column a required field?Planet Technologies || SharePoint Task Force

Hello, I am also experiencing this problem. Custom list lookup fields in datasheet edit view prompt for entry with "Windows Internet Explorer" error message "the text entered isn't an item from the list. Select an item from the list, or enter text that matches one of the listed items." Fields are NOT flagged as required. Datasheet View: Fields do not display data. Clicking ok on error then pressing delete permits record to save. However browsing SP list using Access field will show a 0 in each field when field should actually be null. Standard View: fields do not display data. Editing record through the edit button permits record update with no errors. Browsing SP list using Access still shows a 0 in the field. Attempting to edit record in Access without clearing the 0 from the field errors out with message "You cannot record your changes because a value you entered violates the settings defined for field fieldname (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again." Vista Enterprise edition IE version:7.0.602.18005CO Office 2007 sp2 mso 12.0.6535.5002 Attempted hotfix 948952: not applied. message="Hotfix for Office (KB948952)" "the expected version of the product was not found on the system" In summary: SharePoint places a 0 or does not clear a 0 from a custom list lookup field when the user clears data from the field or selects (none) from the drop down list.

hi - This issue has been driving me crazy. Especially because it just started to happen. I was making updates in the datasheet view without issue, then all of a sudden I cannot. Did you ever find an answer to this aside from recreating the list?

I would love to hear a solution if anyone has it. Just like Valerie, I don't remember this happening in the past, but it does now and despite looking through lots of forums I haven't found an answer.

Anyone found the answer yet? We have found it happens on clients with Windows 7 Professional and Office 2010. Datasheet mode only. No issue on Windows 7 and Office 2007.

We also have this very annoying problem with clients using Office 2007. Does still nobody know of any solution?

I am experiencing a similar issue at the moment however it is on one machine, the client machine when updating any field within a row shows the lookup column error message you mentioned. However I can make changes just fine on my machine. Will investigate a bit further but was wondering if a solution was already found for this?

I am curious to find a solution to this problem as well. In my case this occurs for 3 out of 5 people who have a System with XP SP3, Office 2007 and IE7. I don't have admin privledges to find out what the configurations of the machines are and see if there are any differences. I do know that Active X may be a problem. Check to see if your browser supports Active X, if you are on internet explorer see if your site in in the trusted sites. maybe this will help for you. Chillypfcjt@hotmail.com

We had users with the same problem on XP and Win7. What fixed it was repairing MS Office. Control panel>Programs and features >select MS Office ... >click on Change >select Repair.

Ok. I don't know if this was the actual fix to the problem in our network. But users who were experiencing this problem recieved a .Net Framework 3.5 SP1 Patch and this issue was no longer a problem. Hopefully this helps somone who reads this post. pfcjt@hotmail.com