"We found a problem with some content in *****.xlsx" on Excel 2016, but works perfectly on Excel 365

Hi everyone,

As a side project at work, I created and maintain a large Excel workbook that we use to track various data points for research purposes. I don't have access to our work network at home so I update the Excel workbook a lot of the time at home. Whenever I go into work I put the updated workbook on the network drive. I have been doing this for 2 years and never had an issue... until this past Tuesday.

When I put the workbook on the network drive and tried to open it to edit it I got the dreaded message:

"We found a problem with some content in '2022-05-17 MSTU Data.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

I click yes and of course it messes everything up and it is unusable. The removed parts it says are something with Print Options and repaired parts are from sheet5 (see attached images).

The odd thing is that it works perfectly when I open it at home. I have an iMac with the latest MacOS and use Office 365. The work computers have Office 2016. One of my coworkers also works on the worksheet at home and he uses a Windows laptop with Office 365, and it opens perfectly for him as well.

Luckily I keep backups every time I work on the worksheet by using Save As and creating a new version with the date I worked on it (that's why it's titled with the date above). So if there is no fix it is not as bad because I won't lose too much data, just got to try to not do the same thing again. I'm guessing something I did between the 2022-05-16 and 2022-05-17 version is what Excel doesn't like on the work computers.

Does anyone have any ideas why it will work on our personal computers with Excel 365, but not the work computer running Excel 2016?

Thanks