Error in using excel using "change source data" option in modifying chart

Question

I am trying modify a CHARTin EXCEL using the 'change source data' option. However, EXCEL quits with a message "THERE IS A PROBLEM WITH MICROSOFT EXCEL AND WE APOLOGIZE FOR THE INCONVENIENCE. MICROSOFT EXCEL WILL ATTEMPT TO RECOVER YOUR WORK"

It does not recover anything and i start over again.

IS THIS A MICROSOFT ERROR? WHAT IS THE APOLOGY ABOUT?????

This problem surfaced last week. ??????

Answer 1

Please note that this forum is not Microsoft Support; it is a community for users to help one another.

As a forum moderator, I’m here to help guide discussions and share insights based on Microsoft documentation and community knowledge. Although I don’t have direct access to the back-end system to recover file for you, I’ll do my best to support you with practical steps and point you to the appropriate resources.

Hi @Robert Goldstein

I apologize for this situation, I know this must be affecting your workflow a lot.

As for now, I have not found any document stated it this is an issue for version 16.108.3.

Can you please provide the steps you did when Excel crash? Are you using Pivot Table, from the table, you insert a chart. When you modify the chart with Change source data, Excel will crash immediately?

Do you store your Excel workbook in OneDrive? If yes, you can try View previous versions of Office files - Microsoft Support

If you do not have it stored on the server, last place you can check is in Finder. Recover files in Office for Mac - Microsoft Support

Additionally, if this problem recently occurred, you can try uninstalling the current version and install previous version of Excel where you don't meet this issue. You can download via Update history for Office for Mac - Office release notes | Microsoft Learn

My recommendation is version 16.104.x.

I hope you will be able to find your file.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

THIS IS A PROBLEM THAT RECENTLY SURFACED!

I AM USING MacOS, not Office

My SOFTWARE IS UP TO DATE (05/06/26). I'VE TRIED THAT PATH.

IS THERE A PROBLEM WITH THIS VERSION (Version 16.108.3)?