1

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.

Roan T of Microsoft suggested that I run the Microsoft Office Configuration Analyzer Tool 2.2, which I did, but it didn't report any issues.



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.

Question
The bug may not show on every installation; though I know I'm not the only one. Is there a fix for this?



update
I tried both running Excel in safe mode and repair. No avail.

update 2017-08-03
At least 1 other person could reproduce it on version 8326.2062, but only on Windows 10. On Windows 7 there was no error.

  • Can you provide the actual data? I got 1,2,3,4,5 all in A1 to A5, and then some random numbers (between 0-99) in B1 to B5, and created a scatter plot as you said, Formatted B1 to "Numeric" with 3 decimal values, and it saves without issue. I am on Excel 16.0.8229.2086 (32-bit) - not sure if that make a difference? – Darius Aug 1 '17 at 6:57
  • @Darius - I used 1, 2 and 3 in column A, and 10, 4 and 5 in column B, but I get the error with any set of values. I formatted the 10 as 10.000, but also here it doesn't really matter which number you pick. I guess it has to do with your version being slightly older, or even the 32-bit (I thought I have 64-bit; where can I see that?). Anyway, thanks for your time. – stevenvh Aug 1 '17 at 7:04
  • If you click on File - Account - "About Excel" - it will open the About Microsoft Excel, and the top line will say what version (and 32/64 bit). I'll see if I can update it to your particular version and get the same bug. EDITED to add: I tried with your data, and same steps, add data, make scatterplot, format 10 to 3 decimal places, and save - still no error. – Darius Aug 1 '17 at 7:06
  • 1
    @stevenvh, it's a meta tag. A "bug" could refer to most of the questions on the site without really differentiating anything (and people would use it for useless decoration). We don't have any experts in bugs. :-) – fixer1234 Aug 1 '17 at 8:28
  • Are you saving this file locally or onto a network? Also, what are your locale settings? Under region in control panel. I wonder if something there has made this occur – Dave Aug 1 '17 at 8:30

protected by Community Aug 3 '17 at 10:59

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).

Would you like to answer one of these unanswered questions instead?

Browse other questions tagged or ask your own question.