I don't have any other ideas.

Can you upload an example workbook with a limited amount of data just to illustrate the problem? No need for it to be a big file.