Best advice - re-educate the other department to implement Excel in a stable manner.
For the unwary merged cells are a disaster in the making - especially if the financial integrity is believed and critical.
There is ample information on the net from experts, how to NOT use merged cell and proper structures if you intend using Excel as a pseudo database.
If you intend to use Excel for reports do not use the report template as the data store.