Need a solution to keep a version history of Excel files
Posted on 2013-11-11
I have a requirement where the Finance dept want people to save each revision of an Excel workbook to a folder but they shouldn't be allowed to delete or modify any existing files They should also be able to read them.
I have done a few hours of testing NTFS permissions to try and make this work but its seems to be a bit of catch 22 type situation to me. They can write new files but cant write existing files? There are such no granular NTFS permissions for that from what I can tell but I don't claim to be an expert by any stretch.
Is there a way to allow new files to be created but make them read only once they are created?
Do you guys have any recommendations on how to solve this problem? I am starting to look at things like TortoiseSNV and Git because I am beginning to doubt I can solve this with NTFS permissions alone. However I am very reluctant to proceed down this path as it appears that it would require a lot of training of already change resistant users in order for them to use such a solution correctly.
Is there an idiot proof solution to my problem?
Thanks in advance