Hi guys,

Over the last couple of months I have been teaching myself VBA, in order to make things at work a little easier.

I have ended up creating a useful tool for some of our teams, however recently the number of people using this shared file has doubled.
Since then the file corrupts multiple times a day.


I have spent hours trying to identify how to find a solution to improve this, but all have failed.

My last lead took me to lookingat the XML of the file, by changing it from .XLSX to .ZIP. But I cannot make head nor tail of it and
am at a loss as where to turn. I am accutely aware of the many issues with using a shared file, but at present there is not a great
alternative and I would hate for all my work to be for nothing.

The error log gives the below for each sheet:

removedFeature>Removed Feature: View from /xl/worksheets/sheet1.xml part</removedFeature
Does anyone have any idea how to fix so it stops corrupting or where I need to look in the XML to find the issue? Something to do with the view on each sheet?