R
R
Rail2016-01-31 23:29:59
Google
Rail, 2016-01-31 23:29:59

Collaboration in an Excel workbook through the "cloud" with access control?

Good afternoon!
Tell me, how is it better to organize collaboration with an excel book and restrict access?
Introductory:
The file has about 25 users (different networks)
Each of them fills in the data on his sheet and should only have access to it. The appearance of the editor should resemble ms Excel 2010/2013 as much as possible, ideally edit through it.
How can I do this through the cloud or a similar solution?
one note? sharepoint? GoogleDocs? If possible, at least a brief instruction)
What difficulties and limitations can there be?
How to properly restrict access?
upd
Data from 25 sheets is summarized on one sheet and the manager should be able to see not only the summary data, but also where they
came from. The file is used once or twice a month.
I would like to use exactly Excel, tk. when the user walks through the sheet with his data, he changes the chart (the macro replaces the data for the chart depending on the active cell) and, based on it, he makes adjustments.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
slkl, 2016-03-08
@slkl

The idea of ​​giving a bunch of users shared access to one file is not the best. Do not be fooled by Microsoft's advertising that Excel makes it possible to easily organize multi-users. What prevents you from accessing the database via ADO from Excel, for example? The basis to be twisted on the server, Excel as the client.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question