Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

excel file sharing with multiple user access and revision controls

Avatar of mike arai
mike arai asked on
Microsoft OfficeMicrosoft ExcelSpreadsheetsWindows Server 2008
5 Comments1 Solution108 ViewsLast Modified:
i am looking for a solution configuration which will allow multiple authorized users to access an excel workbook to update content/information.
parameters would be:
-users are all remotely accessing the spreadsheet. (currently approx 5 users need access to the files)
-need some level of revision controls where users to avoid data conflicts
-existing spreadsheets have multiple links to other spreadsheets
-existing spreadsheets have embedded macros to automate input
-ideally if we can track who has made changes or is using the file it would be helpful
-ideally if concurrent access is available and can manage updates it would increase our efficiency rather than only one users updating at a time

right now we are using a local server with 3 Remote desktop cals; however, we wanted to move this to a hosted solution with automatic backups

any guidance would be greatly appreciated.
i would be willing to retain someone to help implement the solution if available.

thank you again
Avatar of Rob Henson
Rob HensonFlag of United Kingdom of Great Britain and Northern Ireland imageFinance Analyst

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answers