Excel no longer able to run a macro-enabled workbook correctly

Question

Hello,

I am having trouble using a Macro-Enabled workbook. Just for background knowledge: this workbook was created by a 3rd party and used to import data (from their product) and create a usable report for us and our clients. Because it was created by a 3rd party they have password protected their Visual Basic code and will not give out the password to it.

That being said, I contacted their customer support team and they were not able to replicate the issue on their end given the exact same source data, workbook, and version of Excel. They suggested the problem was likely some sort of internal IT setting or that a Windows Update had affected Excel's ability to run the Macro. One of their suggestions was to try the file on another computer that didn't have the same settings as our work computers. So I ran the workbook on an old laptop with Excel 2010 on it and their workbook worked.

Getting to the point: when I try to run the Macro (in Excel 2016) I get the following errors:

1st an error pops up regarding merged cells: "merging cells only keeps the upper-left value and discards other values". If I click OK, the macro just repeats endlessly. Eventually I have to press cancel. Next, a Visual Basic Error pops up: Run-time error 1004: Unable to set the MergeCells property of the Range class. I click End and see about 1/10th of the report is completed. 

What steps can I take to resolve this issue?

Thanks.

Answer 1

Counterquestions:

Is it possible that I can have a copy of the file and run the macro on my PC?

Are you interested to get support from a 4th party?

If so, please look into my profile for my mail address and send me the file, I'll take a look.

Andreas.

Answer 2

Thank you Andreas. I will email you shortly.