troubleshooting Question

excel file sharing with multiple user access and revision controls

Avatar of mike arai
mike arai asked on
Microsoft OfficeSpreadsheetsWindows Server 2008Microsoft Excel
5 Comments1 Solution108 ViewsLast Modified:
hello,
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
Mike
ASKER CERTIFIED SOLUTION
Rob Henson
Finance Analyst

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

Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros