Unable to save file (Well... Sometimes)

[Bluetube]

I have a workbook that is saved as binary .xlsb that we (three people) use on a daily basis. Starting around January of this year, about once a week after one of us would open it and select save, we?d receive an error message stating the file is corrupt and can?t be saved.
We managed to find a work-around, if one of us that did not receive the error message open, save the workbook and then close it. Then the person who received the error before can now save the workbook without any issues. Then there aren?t any issues again until usually about a week later.
Over the past two weeks this work-around has been less effective. For instance, this week all three of us were unsuccessful at saving the file.
But for example, if I reached out to someone else (not one of us three) and requested them to open and save the file. Then we are able to save the file again as well.
Even stranger, today I had someone outside our group open and save it. I went in and still could not save it. Then, I asked a different person outside our group to open and save it and then I was able to do the same again, as well as the rest of my team.

Unsuccessful Solutions Tried:
Opened Excel in Safe Mode and did a file repair.
I ensured the three of us had the latest Office updates.
Tried to save the file to my local drive.
Opened Excel changed calculations to manual and then opened the workbook.
Tried changing the suffix from xlsb to xlsm (since it does contain macros).
Posed the question on MS Office Tech Community a month ago but never received a response. (I deleted the post today to prevent cross-posting)
One thing I did notice is when this occurs I am unable to view any of the macros in the workbook. When I select VBA and double click on any of the macros nothing happens. When I select Reference, Tools nothing as well.
I have researched the heck out of this and have not been able to find a solution.

I can't share the workbook because it has sensitive info and it would take me forever to remove all of it. Plus if removing it fixed the issue I would not find the error.

There has never been a corrupt Excel file I have not been able to open or fix. While this one we are able to still find a way to utilize it, I am concerned that we might not be able to one day. This file would take way too long to rebuild. I do not believe this file is corrupt but can?t figure out what may be causing the issue.

[AliGW]

Plus if removing it fixed the issue I would not find the error.

You might want to think that one through again.

If you removed data and it fixed the issue, then you'd know that it was a case of corrupt data somewhere!

But I don't think it's that - if it were, the error would present itself to ANYONE opening and saving the file.

When it happens to you or your colleeagues, is it after editing, or does it happen when you just open and reclose the file?

[Bluetube]

It occurs after editing or just opening the file and saving. The only thing I can think of this issue being related to would be if different users have a different set of updates than others. For instance let's say if the user I reached out to outside our group was able to open and save and then I could as well. If that user is on an older update maybe it allowed them to save. I am just thinking out loud here.

[AliGW]

It might be, but you are the only one in a position to test that theory.

Which version of Excel are you all using?

[Bluetube]

We are all using MS 365 for Enterprise. However, some of us may be on different update channels. For instance my team and I are all on the Monthly Update Channel and I am using Version 2305 (Build 16501.20242). I have reached out to them to provide what version they are currently showing. The person that was able to open and save the file that allowed us to utilize the file again, they are on Semi-Annual Enterprise Channel Version 2208 (Build 15601.20680).