Friday, December 12, 2008

Edit in datasheet without Microsoft Office

Normally in SharePoint if you want to edit a list or library in a datasheet the machine you are using has to have Microsoft Office installed.




But what happens in cases where machines aren’t going to need Microsoft Office otherwise? It seems a little silly to purchase a copy of Microsoft Office just to have the ability to edit in a datasheet with SharePoint.


The solution is to download and install Access 2007 Runtime from Microsoft which is a free download. So now all client machines can have the functionality of using the ‘Edit in Datasheet’ feature without having to purchase an additional Microsoft Office license.