Remote update an Excel spreadsheet

green51

I have an excel spreadsheet with several users on it and I would like each one of them to be able to update it via the internet. Shall I use a javascript to do this? I am currently using Excel 2003

Thanks..

gits

how do the users access the spreadsheet?

kind regards

green51

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.

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

green51

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

gits

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

insertAlias

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

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?

green51

Quote:

Originally Posted by insertAlias

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

Do you mean Sharepoint Designer?

green51

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

Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

re: Remote update an Excel spreadsheet

Similar Misc bytes

/bytes/development

/bytes/it

/bytes/about