I have Office 365 Home.
I have an Excel file consisting of a table of numeric data and a chart representation of this data. The file was created and last saved with Excel 2016.
Then when I got a notification about an Office update the file wouldn't save anymore, giving me the following error message:
"Errors were detected while saving [filename]. Microsoft Excel may be able to save the file by repairing or removing some features. To make the repairs in a new file, click Continue. To cancel saving the file, click Cancel."
Excel wasn't able to repair the file. I assumed a bug had snuck in with the updated version, but apparently the update hadn't even installed yet. I had version 16.0.8229.2103, and updated to the most recent version, 16.0.8326.2059.
How to reproduce
I have Office installed on 2 computers, and the bug appears on both installations and is easy to reproduce.
Create a small table of numeric data, select it and insert a chart. (I used a scatter chart, but the problem pops up with other chart types too.) Then format at least one cell in the table as numeric with at least 3 decimal places. Try to save the spreadsheet.
That when I get the error message. Can anyone please try this on his/her computer to see whether the bug is consistent?
Try to save in the default "Excel Workbook (*.xlsx)"; saving as .xls doesn't cause the issue.
The bug may not show on every installation; though I know I'm not the only one. Is there a fix for this?
I tried both running Excel in safe mode and repair. No avail.
At least 1 other person could reproduce it on version 8326.2062, but only on Windows 10. On Windows 7 there was no error.