Using Excel spreadsheet online

  • Thread starter Thread starter Monkeysuit Man
  • Start date Start date
M

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?
 
Monkeysuit Man said:
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.
Click to expand...

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.
 
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?
 
Monkeysuit Man said:
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?
Click to expand...

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.
 
Back
Top