Solved

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

Posted on 2014-10-31
3
2,046 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

Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

Suggested Solutions

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 how to maximize accessibility options in an Excel workbook for users with accessibility issues.
Viewers will learn what comprises a theme in Excel 2013, as well as how to customize them.

810 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