Hello...

I have an excel file with different worksheets. One of the worksheets is named "Import" and ideally its only purpose is to be populated with values from a text files that I then process and format by hand copying them in another worksheet.

I can insert "Data from text" with no problem, and "Import" gets populated exactly how I want it to be.
The problem is when I click "refresh": a window pops up, saying "this operation will cause some merged cells to unmerge. Do you wish to continue?".

If I click "yes", excel unmerges some cells in other worksheets that has to stay merged for formatting purposes, and I don't understand why, since the other worksheets are not linked to the "Import" worksheet in any way.

Can someone explain what is happening and how can I prevent it to unmerge my cells?