The joys of working with Microsoft products!
So I have a brand-new, shiny 17″ HP laptop. 64-bit throughout. 6GB of RAM and comes pre-installed with 64-bit Windows. You would think, then, that you would want to use 64-bit applications right? Wrong!!
I automatically use the 64-bit version of Internet Explorer to access some Microsoft specific sites (Outlook Web Access and SharePoint 2007). I install and use the 64-bit version of Microsoft Office. Does this work well with SharePoint (from Microsoft)? No!
For starters, you cannot upload an Excel spreadsheet to a SharePoint list like you should be able to. You get an error:
Next you try to switch a list into a “Datasheet” view – which looks a bit like a spreadsheet. Inevitably, you get another error:
To fix these errors, you then have to download and install “2007 Office System Driver: Data Connectivity Components“. And you have to use the 32-bit version of Internet Explorer 9 (IE9).