How do I put a File (Excel) online (Apache Server) with Password Protection but with the Option for Users to alter the File and save the changes?

Question

I have to put an excel file online on a web server (Apache) with some basic password protection (basic http auth). User, however, should be able to open the file from within excel and save their changes back to the server.

Is there any simple and effective solution for it? I am not very experienced with webdav.

Answer 1

Funny enough, if you just need "basic-level" security, you can set it up in the Excel sheet itself:

Go to the Tools -> Protection menu and you can lock down the whole sheet, or just specific ranges.

Note This is not "really good" security and will not stand up against an even moderately-skilled attack...but it will pass muster for the most basic uses.

Answer 2

Maybe use Google Docs to share the document. That would be as turn-key as it gets. :)

Answer 3

Webdav can do this. Might be a hassle to set it up.