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

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
floyd197Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

tshearonCommented:
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
EirmanChief Operations ManagerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
floyd197Author Commented:
Went for the shared Workbook option. Now working as we want.

Many thanks
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Spreadsheets

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.