I have an Excel 2019 file with approximately 62 sheets (tabs) and file size 4.5 Mb. I edit the file, make changes, add to it, etc. several times a week. Every day that I am finished, I save and rename the file. Every so often the file has become corrupt. I have traced the problem to four sheets (tabs) where there is an Advanced Filter. Has anyone else experienced this?

Another person also edits the file periodically with Excel 2016. We share the file by uploading and downloading to/from the BOX cloud application.

Another question - when you repair an Excel file, how much confidence do you have that everything is returned back to where you started?

Thank you.