Remote update an Excel spreadsheet 
June 28th, 2008, 07:38 AM
| | Newbie | | Join Date: Jun 2007
Posts: 18
| | |
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..
|
June 28th, 2008, 11:57 AM
|  | Moderator | | Join Date: May 2007 Location: Munich, Germany
Posts: 4,102
| | | re: Remote update an Excel spreadsheet
how do the users access the spreadsheet?
kind regards
|
June 29th, 2008, 03:34 AM
| | Newbie | | Join Date: Jun 2007
Posts: 18
| | | re: Remote update an Excel spreadsheet
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.
|
June 29th, 2008, 09:30 AM
| | Moderator | | Join Date: May 2007 Location: Munich, Germany
Posts: 4,102
| | | re: Remote update an Excel spreadsheet
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
|
June 30th, 2008, 05:32 AM
| | Newbie | | Join Date: Jun 2007
Posts: 18
| | | re: Remote update an Excel spreadsheet
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...
|
June 30th, 2008, 06:02 PM
| | Moderator | | Join Date: May 2007 Location: Munich, Germany
Posts: 4,102
| | | re: Remote update an Excel spreadsheet
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 ...
|
July 1st, 2008, 11:17 PM
|  | Forum Leader | | Join Date: Apr 2008 Location: San Antonio, TX (USA)
Posts: 2,569
| | | re: Remote update an Excel spreadsheet
Sharepoint would be perfect for this. It's not cheap though.
|
July 16th, 2008, 01:21 AM
| | Moderator | | Join Date: Mar 2006
Posts: 1,103
| | | re: Remote update an Excel spreadsheet
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?
|
July 17th, 2008, 04:28 AM
| | Newbie | | Join Date: Jun 2007
Posts: 18
| | | re: Remote update an Excel spreadsheet
Quote: |
Originally Posted by insertAlias Sharepoint would be perfect for this. It's not cheap though. | Do you mean Sharepoint Designer?
|
July 17th, 2008, 04:41 AM
| | Newbie | | Join Date: Jun 2007
Posts: 18
| | | re: Remote update an Excel spreadsheet
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..
|  |
| | |  /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,689 network members.
|
