Forum Discussion
BartBpl
Feb 19, 2024Copper Contributor
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 ...
- Feb 22, 2024
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.
JKPieterse
Feb 19, 2024Silver Contributor
I wouldn't know any that offers what you are requesting. But it isn't going to be a simple tool to build!
- BartBplFeb 19, 2024Copper Contributor
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 😉
- JKPieterseFeb 20, 2024Silver Contributor
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.
- BartBplFeb 21, 2024Copper ContributorSo 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?