Sometimes leading minus sign in a cell with text is treated as a formula.
A possible workaround is to remove the minus sign or to replace it with some other symbol.
When there are unclosed quotes (") several cells/rows are imported as one.
A possible workaround is to replace all the quote (") symbols with single quote (') symbols.
When an xlsm file is imported and then exported, a new ThisWorkbook object is created in the VBA browser. This creates issues when making VBA functions that have to be executed upon opening of the file.