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?