team work on one excel

hi Team,

I run a company of 10 employees, we use Dropbox business for file sharing. we have a lot of issues with excel where if two or three staff working on the same time, the file get duplicated or conflict. i need a solution where all staff can work simultaneously on the same excel.

thank in advanced.
AussieSilverAsked:
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.

RizzleCommented:
We have this issue at our place and there hasn't been no resolution to this problem yet, the users who share the spreadsheets consistently get Sharing Violations etc etc and the spreadsheet consistently gets corrupted and needs to be restored from backup.

You could share the spreadsheet but even Microsoft don't recommend this anymore.

http://office.microsoft.com/en-gb/excel-help/use-a-shared-workbook-to-collaborate-HP010096833.aspx
0
slubekCommented:
If you have to use Excel, the only way to edit the same file by multiple persons is using Sharepoint Excel Services.

If not (and you don't mind putting your business data to Google cloud), you can use drive.google.com .
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
AussieSilverAuthor Commented:
Thanks guys, it seems Sharepoint Excel Services is a great option.

I would love to go with ahead, can you advise how to get this service ?
0
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

AussieSilverAuthor Commented:
i have now created a sharepoint site with my provider, i need to know how to set up  Sharepoint Excel Services
0
slubekCommented:
SharePoint works on top of MS IIS webserver. Unfortunately, I know nothing about it's installation.
Of course, you can google some "free sharepoint hosting" sites, but, again, it means putting your data outside your company.
I think you'd better ask some IIS/Windows Server admin how to install/configure IIS safely.
After you have SP installed you only have to enable Excel Services for your new created SP site and  publish your files.
0
slubekCommented:
You were faster with getting SP than me with answering you. :^)
Ask your provider for enabling Excel Services - it has to be done by administrator, normal user cannot do that. At least in my organization.

More about Excel Services you can read here
0
AussieSilverAuthor Commented:
Haha
Yes, yes I need to get the solution asap . I'll ask my provider to set it up

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
Microsoft Excel

From novice to tech pro — start learning today.