I’m implementing a logic to check if records are deleted from excel files.
I have 3 excel sheets, data will be updated every hour in these files.
What is the best activity to monitor if any records were deleted?
You can track Excel change my its own in build function for that
Open Excel and click on the ‘Review’ tab on the ribbon. At the far right, you should see an option called ‘Track Changes’ under the ‘Changes’ section.Click the button and choose ‘Highlight Changes’ . You’ll get a dialog box where you now need to check off the option ‘Track changes while editing. This also shares your workbook’ .You have several options here including ‘When’ , ‘Who’ , and ‘Where’ , you can give your preference.