Hi Everyone ,

I would like to know how I can host an excel file on a server that would allow a user to access , view and modify/add some content to the file via the internet without downloading the file itself. Each user will access a copy of this file that they will be able to use and save any changes, under their own name, they may have made back to the server for future use. The user should not have the option to download the file, save it on their computer or be able to view or change certain cells, columns, rows or view the VBA code behind it. The user will access the file via a website using a provided login and password. While the file is open and in use by the user, some cells will be updated in real time drawing on information and values from 3rd party software (DDE links).

While the overall structure seems to be fairly straightforward – a server, a website and excel. It becomes murky when I try to work out the details in how exactly to connect the three. I understand that ActiveX plug-in maybe needed in order to allow the user to open the excel file in IE but I have a feeling there maybe something more to it than just that.

I would like to know your opinion and view on the best approach to achieve this task.

Sonia