I want to use Sharepoint to host a table that multiple people can edit (like an online spreadsheet, for example). I have tried various things which have not worked:

I tried downloading a plugin for excel that has a "Share & Publish to Sharepoint" button, but when I use it I get a VB runtime error and a message saying could not connect to server.

I tried uploading a spreadsheet and creating a "data view" but once it is done, I get the message that "Standard view is being used because my browser doesn't support activeX". I am using IE and have turned on all activeX permissions in Internet Options.

What is the easiest and best way to create an editable table in Sharepoint that anyone can edit, that can host drop-downs in the cells, and which is filterable?


  • 2
    Are you on SP2013? Why not use Office Web Apps?
    – Joe
    Jul 15, 2015 at 2:55
  • Unfortunately the company I work for has banned the use of Office Web Apps, OneDrive, Google Docs and anything else that would work for this.
    – zeeple
    Jul 15, 2015 at 3:54
  • Datasheet view is suitable for your requirement. Also check activeX issue is coming to you only or others also.
    – P S
    Jul 15, 2015 at 5:08
  • I would like to use the datasheet view solution, but the Active X problem is frustrating. I have tried 32 bit IE, Firefox and Chrome and none of them will work. In IE, I went into the security settings and enabled all ActiveX, but still no love.
    – zeeple
    Jul 15, 2015 at 5:38
  • Check this link: social.msdn.microsoft.com/Forums/sharepoint/en-US/…
    – P S
    Jul 15, 2015 at 6:22

2 Answers 2


You can create a datasheet view. A datasheet view will allow anyone to edit, as long as you give them the correct permissions.

enter image description here

As long as you have a dropdown field on your list you can use it in this view.

enter image description here

You can also filter the list from the columns just like any other SP list:

enter image description here


In the view settings you can enable "inline editing".

This enables a button which when clicked makes the row editable.

It even shows dropdowns when you have defined the column as multiple select.

Your Answer

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

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