DEV Community

01kg
01kg

Posted on

Excel | Merged Cells Broken Up? Excel Keeps Crashing? Try to Update!

TL;DR:

  1. I have an Excel file, .xlsx, contains some spreadsheets, and many merged cells in each spreadsheets. Opens in computer A, works well. A has an Excel of version 2211

  2. The data in it is written by openpyxl package of Python.

  3. I copied the file to computer B, the excel version is 2209, opened it, all merged cells are broken up (unmerged, split up). Not only this, Excel crashed 3 times before opened it up.

  4. Firstly, I though it is openpyxl's fault. No, it is wronged.

  5. Ended up some bugs related to this issue were fixed in versions above 22.09.

  6. Update B's Excel (of course the whole Office actually), bump up to 24.11, opened the same file, all merged cells are back!

Top comments (0)

A Workflow Copilot. Tailored to You.

Pieces.app image

Our desktop app, with its intelligent copilot, streamlines coding by generating snippets, extracting code from screenshots, and accelerating problem-solving.

Read the docs

👋 Kindness is contagious

Engage with a sea of insights in this enlightening article, highly esteemed within the encouraging DEV Community. Programmers of every skill level are invited to participate and enrich our shared knowledge.

A simple "thank you" can uplift someone's spirits. Express your appreciation in the comments section!

On DEV, sharing knowledge smooths our journey and strengthens our community bonds. Found this useful? A brief thank you to the author can mean a lot.

Okay