Avatar of mike arai
mike arai
 asked on

excel file sharing with multiple user access and revision controls

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
Microsoft OfficeSpreadsheetsWindows Server 2008Microsoft Excel

Avatar of undefined
Last Comment
Seth Simmons

8/22/2022 - Mon

With these requirements, Excel is not the tool you should be using.  You need to us a real database application.
Adam Brown

Sharepoint Online is a good solution for your purposes. It will allow you to host Excel files with live collaboration between users, versioning controls and auditing, and various other features. A database solution is probably a good way to go as well, but it's likely going to cost significantly more than just signing up for Sharepoint Online with 5 users, then using the Office Web Apps that comes with to work with the Excel file.

Natively, though, there's really not a lot you can do for managing files the way you describe.
Mike A

with sharepoint online, will the excel spreadsheet macros and references all work?  someone told me that excel web does not work with macros
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Rob Henson

View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Seth Simmons

No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: Rob Henson (https:#a42107407)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

Experts-Exchange Cleanup Volunteer