Remote update an Excel spreadsheet

how do the users access the spreadsheet?

kind regards

Quote: Originally Posted by gits how do the users access the spreadsheet? kind regards

Each user will be able open the spreadsheet over the internet and once they open it they update their area of information.

what do you mean with 'over the internet'? i assume that you just have a link on a website and the users download the file and open it? so you need to upload the file back to the server and handle it there with serverside code ... so that the 'base'-file will be updated according to every users changes.

kind regards

Quote: Originally Posted by gits what do you mean with 'over the internet'? i assume that you just have a link on a website and the users download the file and open it? so you need to upload the file back to the server and handle it there with serverside code ... so that the 'base'-file will be updated according to every users changes. kind regards

yes that is correct...

so as you see ... since JavaScript is a client-side language you shouldn't or better you couldn't use it for your purpose ... and you should look for a serverside solution to read and write excel-data ... what you choose depends on your prefs like php, asp, jsp or whatever ...

kind regards

ps: ah ... and since excel is not a database you have to handle all possible concurrent use for your own ...

Sharepoint would be perfect for this. It's not cheap though.

I thought sharepoint too, but it would be overkill if you only want to update 1 spreadsheet. Are you planning on sharing many other files, or just this 1?

Quote: Originally Posted by insertAlias Sharepoint would be perfect for this. It's not cheap though.

Do you mean Sharepoint Designer?

Quote: Originally Posted by jkmyoung I thought sharepoint too, but it would be overkill if you only want to update 1 spreadsheet. Are you planning on sharing many other files, or just this 1?

On this sheet i have abot 20 users..