Using Excel spreadsheet online

[Monkeysuit Man]

I have built a spreadsheet that allows me to track inventory and
revenue for products that i have a team of people selling. I sthere
any way that I can post this spreadsheet online so that my salespeople
can update it from a browser? I know a bit about Excel but I don't
know diddly about what might be needed on the server end or how it
would save the data.

Any sugestions?

 

[Fabian]

I have built a spreadsheet that allows me to track inventory and
revenue for products that i have a team of people selling. I sthere
any way that I can post this spreadsheet online so that my salespeople
can update it from a browser? I know a bit about Excel but I don't
know diddly about what might be needed on the server end or how it
would save the data.

I don't think there is an easy and secure way to do it. With the normal
set of permissions, it would be publicly readable, but not editable. You
could of course set it to be publicly editable, but then anyone who has
a web connection could edit it. I think you'd need to also put it in a
secure passworded folder.

Ive never tried doing anything like this. I might be on the wrong track
here.

 

[Monkeysuit Man]

I can export the spreadsheet from Excel in an interactive HTM format.
And I can probably find someone to help me with the password
protection. My main issue is how do I get the HTM version of the
spreadsheet to save the inputted data onto the server? What form does
the data take? What do I need running on the server to accept the data
from the altered spreadsheet?

 

[Fabian]

I can export the spreadsheet from Excel in an interactive HTM format.
And I can probably find someone to help me with the password
protection. My main issue is how do I get the HTM version of the
spreadsheet to save the inputted data onto the server? What form does
the data take? What do I need running on the server to accept the data
from the altered spreadsheet?

All the data would be stored within the excel file, which presumably is
on the server. Normally, the files on a web server are set to read only
access unless you log in with administrator priviliges with your user
name and password. Some ftp programs include a way to modify these
permissions, but this will also depend on your web host.