I'm working with personnel data in my job, including lots of details which I know to be sensitive and most certainly covered by GDPR.
In order to maintain compliance with the regulations while preserving the ability of our team to work on the same spreadsheets, we have hidden sheets and locked the Excel workbook every time it has been saved. This effectively obscures all personal data behind password protection.
A problem I have noticed however is that once the spreadsheet is unlocked and in use, MS Excel makes "AutoRecovery" copies of it which are accessible upon opening Excel.
I wanted to check where things stand under these circumstances - of Excel autosaves effectively leaving a copy of the document without password protection. I presume this is non-compliant, if this is the case, is the only way around this to turn off autosaving and recovery mechanisms from Excel (providing this is possible)?
Many thanks for any answers to what I hope is a fairly clear-cut question, but I can't be sure of my assumptions on the matter.