Excel Binary Workbook crashing while trying to save after Power Query update

Question

Hi,

I seem to be having a problem with an Excel 2016 binary workbook crashing while trying to save after the latest Power Query update. It saves fine on the older version but crashes after updating Power Query to the newer version. Could someone please assist?

Not working:

Working:

Answer 1

Hi Faheem!

I'm Jen, and I'd be happy to help you out with this issue.

Try repairing your Office installation by following the instructions in the given link below and see if it helps resolve the issue. Let me know if this works.

https://support.microsoft.com/en-us/office/repa...

I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

Best Regards!

Jen :)

Answer 2

Hi Jen,

I have tried this fix and unfortunately it hasn't resolved the problem. The problem is only with one specific document which is an "Excel Binary Workbook", if we try to save it in a different format it works and a newly created Excel Binary Workbook saves fine, but just this specific one doesn't, I think it may be due to the links that it contains.

Also note that it saves fine with the older version of Power Query but as soon as upgrading to the newer version it crashes while trying to save.

Answer 3

Hi Faheem,

If you copy and paste the data to a new workbook and save it in xlsb format, do you still get the same error? Thanks in advance.

Kind Regards.

Answer 4

Hi Jen,

Copying and pasting the data into a new document still hasn't resolved the problem. It's when trying to save an "Excel Binary Workbook" that this happens.

I think that this is a bug with the latest Power Query update and Microsoft needs to find a fix for this please.

Answer 5

Hi Faheem,

I suggest you report this issue directly to the related team for further investigation. You can provide a feedback in the Excel application by going to File > Feedback > Send a Frown. Here's a link for more information. Thank you.

https://support.microsoft.com/en-us/topic/how-d...

Kind Regards.