I have multiple users who are unable to save in the latest .xlsx format for Excel 2016. When saving to .xls 97-2003 it will save but with compatibility issues due to the macros.
It's affecting users locally on their desktops and also on the network drive. For some it's only one specific file. They can be using Win 10 or 7 with Office 2016 32bit. The files they use range from 100KB to 10MB as they use macros and all sorts.
Tried setting all Excel sheets to 100%, all files have the same permissions as any network file should and the location being saved doesn't matter, it will still crash. Users from IT with and without full network access have tried and can save.
I have checked the event log viewer but couldn't decode any data.
We think it's a Microsoft update but haven't been able to pull enough data from those affected to cross reference them. The only thing we know so far is that all the PCs are on one building site out of multiple locations. We believe this is due to the way the updates have been pushed to our network. The issue seems to occur a few days after Windows updates are downloaded.
Thank you very much.
Bookmarks