Solved

Need an alternative to sharing an Excel file or a better way of doing it.

Posted on 2014-10-31
3
2,195 Views
Last Modified: 2014-11-21
We have an excel spreadsheet used to plan the drivers routes at our small haulage company. This is changed everyday and one spreadsheet could contain weeks, maybe upto a month of workbooks. Then when it gets a bit large the details are copied into a new one and so on and so forth.


The time has come so that more than one peson requires access to it. It doesn't have to be real time but it would be
useful. We have tried sharing the workbook but to varying degrees of sucess. Sometimes it is ok. But recently when you try and save changes it will not let you, and displays an error message relating to anti-virus.

Are there any other better ways of achieving this?.

Thanks in advance
0
Comment
Question by:floyd197
3 Comments
 
LVL 8

Expert Comment

by:tshearon
ID: 40415711
You could go the Sharepoint route. That is the best way to probably do this type of collaboration. However, as an alternative you could use Google Sheets to do this. Since it is online and supports this type of collaboration then it should be pretty easy for you to do and work with.
0
 
LVL 23

Accepted Solution

by:
Eirman earned 500 total points
ID: 40415871
There are at least three paths you can take ....

Sharepoint as already mentioned by tshearon
http://office.microsoft.com/en-ie/excel-help/use-a-shared-workbook-to-collaborate-HP010096833.aspx

Workbook sharing over a network as described here ...
http://www.excel-easy.com/examples/share-workbooks.html

Or simply allow only one user to open the spreadsheet normally, with everyone else opening it in read-only mode.
(Click on the little down arrow on the open button in excel for this option).
0
 

Author Closing Comment

by:floyd197
ID: 40457027
Went for the shared Workbook option. Now working as we want.

Many thanks
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
: Microsoft Office Collaborate for free and online versions of Microsoft  Word, Excel, Powerpoint, OneNote, Onedrive , Email, Calendar etc. In short we can say that Microsoft office is a suite of servers, applications and services developed by  Micr…
Viewers will learn the basics of formula auditing in Excel 2013.
Viewers will learn the basics of printing in Excel 2013 and how to adjust some common settings.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question