Forum Discussion
Solved
Controlled and Commented Changes in Excel Spreadsheet
Hello, I am currently searching for a solution or method that would enable me to implement advanced change control in an Excel spreadsheet. My requirements are quite specific, and so far, I haven't ...
BartBpl I suggest to google for "excel audit trail software", it should get you a relevant list of software that handles this kind of thing.
I wouldn't know any that offers what you are requesting. But it isn't going to be a simple tool to build!
Thanks for your comment. At least, I need to make sure that nobody is able to turn off the changes tracking. Honestly speaking, I am surprised it's so challenging 😉
BartBpl The default security settings prescribe that the user will always have to consent to macro's or other code running against the file. Even if you have the code in an Office-js add-in they will have to consent the add-in being installed.
- So there is no way to make sure my users will make changes in the spreadsheet and it won't be listed in the changes history?
BartBpl I suggest to google for "excel audit trail software", it should get you a relevant list of software that handles this kind of thing.