[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 210
  • Last Modified:

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.
0
AussieSilver
Asked:
AussieSilver
  • 3
  • 3
1 Solution
 
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
 
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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now