How to restrict access to certain documents inside a folder?

Question

Access rights

There is a folder, inside about 1000 tables. Every 250 tables are edited by certain employees responsible for the information inside.
It is necessary that each employee could read and edit only their own tables.
Unfortunately, you cannot limit the entire folder.
You cannot use subfolders, because macros and synchronization programs are tied to this (main) folder, adjusting these settings is an even more time-consuming and time-consuming task than setting rights for each individual document.
It is impossible to impose restrictions on 250 tables at once. You can edit the security settings of each table individually, but I would like to find a more reasonable option that does not require so much time.

Answer 1

put protection on each file (in Excel itself, the Reviewing tab)

Answer 2

if all employee accounts are not yet included in any one common group (for example, "Users") - include them in it.
exclude all employee accounts from the "Administrators" group.
for a folder with tables for a common group in NTFS rights, change the scope to "For this folder and its subfolders".
for each file, add the user you want to allow reading and editing, and add "Write data", "Write data", "Write attributes", "Write additional attributes" to its default permissions.

Answer 3

Contact your system administrator or hire a freelancer.
If you don’t know how to correctly differentiate access rights to files and folders and have never done this, it’s easy to make a mistake in one or another checkbox when setting up, and either you block access too much, or vice versa, you don’t finish it, and people’s work will stop - it will simply come out, in the end, expensive.
You need a domain, group policies, setting user and group rights.

Answer 4

Split into separate folders. The employee is allowed to edit in it, the rest can only read or deny access completely. If you need to show all files in one folder, use shortcuts or symbolic links.

Answer 5

There is a folder, inside about 1000 tables. Every 250 tables are edited by certain employees

Well, if employees work with files, then keeping them all in one heap is not the best idea anyway. Break into folders.

You cannot use subfolders, because macros and synchronization programs are tied to this (main) folder

It is not clear why, well, tied up and figs with them.

It is impossible to impose restrictions on 250 tables at once.

Why?
Cacls.exe stopped working?