I've received a couple questions from people who all have issues using datasheet view when using IE 8 in SharePoint 2007. I've reproduced this in MOSS and WSS 3.0 with the same result. I use Office 2003 as well.

Problem 1: Unable to open the task pane

Clicking the task pane on the right side simply does nothing. Can't open it.

Trying to open the task pane

Problem 2: Can't fill down

Before, you could click in a cell, click the little square, and then drag down. This filled all the cells below just like in Excel. Now, it doesn't do anything.

Fill down in datasheet view

Problem 3: Clicking document name doesn't open the document

Before, you could click the document name to open the document. Now, if you click in the Name column it just goes to "edit" mode to rename the file.

Click to open document

Workaround: Clicking on the icon in the Type column to open the document.

I'm trying to get an idea if this is expected behavior or if this is broken. If it is broken, any ideas on how to fix it?

  • I have a similar issue, I installed teh accessdatabaseengine.exe but still cannot use the drag and fill.. any help is welcome.
    – user15932
    Mar 27, 2013 at 19:09

1 Answer 1


This is most likely due to the version difference (O2003 on MOSS2007). After googling around a bit I get the feeling the concensus is that O2003 lets you work with a list in datasheet view, but that fuunctionality is limited compared to when using O2007.

Installing the Access 2007 Runtime (so you don't need the whole product) should fix the problem.

  • Thanks Colin.. I think you are confirming my fears. :( I'll try the Access 2007 Runtime.
    – Kit Menke
    Feb 20, 2012 at 14:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.