Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question
    
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 '13 at 19:09
add comment

1 Answer

up vote 2 down vote accepted

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.

share|improve this answer
    
Thanks Colin.. I think you are confirming my fears. :( I'll try the Access 2007 Runtime. –  Kit Menke Feb 20 '12 at 14:31
    
Yup that worked! Thanks a lot! –  Kit Menke Feb 20 '12 at 14:39
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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