i getting error inconsistently while working excel table connected sharepoint list. similar issue has been reported on technet , indicates due column types such date , time, lookup, or calculated ... know when , why happens? what's more interesting error not consistent, happens randomly. in advance.
moss 2007 on windows server 2003 x86 standard edition
i debugging same issue recently. ran lot of explanations update had changed default value date columns. solutions presented set new, real default value, save, clear out again. others suggested converting text , converting back.
in case able identify column not date field lookup field. pulling hair until ran across this blog post. mentioned problem happen lookup columns pull data calculated columns. that's problem was. except worked when first created. wasn't until after user accidentally deleted lookup column , recreated it. that's when trouble started.
interestingly have lookup column bound same list different calculated column not trigger error.
i did more thorough write-up , explanation on own blog detailing steps went through until solved it.
Comments
Post a Comment