Solved

team work on one excel

Posted on 2014-10-15
7
177 Views
Last Modified: 2014-10-15
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.
0
Comment
Question by:AussieSilver
  • 3
  • 3
7 Comments
 
LVL 13

Expert Comment

by:Rizzle
Comment Utility
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
 
LVL 7

Accepted Solution

by:
slubek earned 500 total points
Comment Utility
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
 

Author Comment

by:AussieSilver
Comment Utility
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
Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

 

Author Comment

by:AussieSilver
Comment Utility
i have now created a sharepoint site with my provider, i need to know how to set up  Sharepoint Excel Services
0
 
LVL 7

Expert Comment

by:slubek
Comment Utility
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
 
LVL 7

Expert Comment

by:slubek
Comment Utility
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
 

Author Comment

by:AussieSilver
Comment Utility
Haha
Yes, yes I need to get the solution asap . I'll ask my provider to set it up

Thanks
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

With the withdrawal of support for Windows Server 2003 this summer, many clients face the issue of moving away from their 2003 installs. There are a few options out there that many people/companies are selling. But the clients I have, haven't wanted…
Cloud file services can fill many different roles for your business. Often, the use of cloud file services begins with employees using consumer products, like Dropbox, to share files with customers and each other. While sync-and-share can be an effe…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now