I am trying to update a Sharepoint list using a Macro in Excel 2010. So far I have had no problems updating regular textual or numeric fields, but when it comes to lookup fields, it throws back an error 0x80002005. I am guessing that you cannot simly use an existing [...] read more