MK5 Golf GTI

General => Random Chat => Topic started by: George on June 26, 2014, 10:03:50 am

Title: Sharing a spreadsheet over a network
Post by: George on June 26, 2014, 10:03:50 am: Hi all,

Is there a way of sharing an excel file or a similar spreadsheet over a network but allowing more than one computer to edit and save it at one time? At the moment the second computer to open the file can only view it as read only, and then if any changes are made it has to be saved as a separate file

Thanks!
Title: Re: Sharing a spreadsheet over a network
Post by: edd666999 on June 26, 2014, 10:09:17 am: Google docs.
Title: Re:
Post by: jason_rmh on June 26, 2014, 10:30:42 am: There's also smart sheet which I think is free for personal use but may be overkill for what you need it for.

http://www.smartsheet.com/coordinate-anything2
Title: Re: Sharing a spreadsheet over a network
Post by: rdfcpete on June 26, 2014, 11:54:10 am: Quote from: George on June 26, 2014, 10:03:50 am
Hi all,

Is there a way of sharing an excel file or a similar spreadsheet over a network but allowing more than one computer to edit and save it at one time? At the moment the second computer to open the file can only view it as read only, and then if any changes are made it has to be saved as a separate file

Thanks!

The only issue with that resulting two edited files is that presumably you'll need these changes to be merged at some point George, which creates bit of a PITA situation?

If it's not going to create too much work and the two files can be merged or edited manually with ease, then no problem. The standard NTFS read/Windows network controls are there to prevent duplication of work though, as annoying as they seem at the time.
Title: Re: Sharing a spreadsheet over a network
Post by: George on June 26, 2014, 12:15:09 pm: Yea I understand that. Is there any spreadsheet software that will run it "live"?

Thanks :happy2:
Title: Re: Sharing a spreadsheet over a network
Post by: DanGB on June 26, 2014, 12:45:26 pm: Office 365 maybe?
Title: Re: Sharing a spreadsheet over a network
Post by: simonp on June 26, 2014, 12:49:26 pm: Use something like Dropbox?
Title: Re: Sharing a spreadsheet over a network
Post by: edd666999 on June 26, 2014, 12:55:17 pm: Quote from: George on June 26, 2014, 12:15:09 pm
Yea I understand that. Is there any spreadsheet software that will run it "live"?

Thanks :happy2:

Yes Google Docs.

All the suggested items so far will save over work done previously or not allow 2 people editing rights.

Sticking it on Google allows live editing by multiple people. It shows an edit history, you can give people read or write access, you can lock sheets to specific members.

Is there a reason its not a possibility?
Title: Re: Sharing a spreadsheet over a network
Post by: George on June 26, 2014, 01:18:55 pm: I've just tried google drive / google docs and I wasn't able to edit the excel document?

Thanks
Title: Re: Sharing a spreadsheet over a network
Post by: Makaveli on June 26, 2014, 01:52:28 pm: As long as the file is on a network share and all the users have access to it then all you need to do is edit the spreadsheet so that it is shared as a workbook. All the users should then be able to view and amend the spreadsheet. If 2 users are in the spreadsheet at the same time and you save the file it flags the file has been amended by another user and highlights the cells.