Monarch Pro 8.02
Data Pump 18.104.22.168
The solution we found to this was first to setup the models as we wanted them to be displayed. Then in Monarch Pro > Options > Export and Clipboard Options and check the box next to XLS Files that says "Apply formatting to XLS".
This has to be done on the machine running Data Pump. That worked for us.
Sorry to revive an old post but hoping to help any others that use the search function.
Other Keywords: header format, column width, keep format, export format.
We did find our solution. For others having this issue (after applying the formatting setting mentioned):
Check the font of the model, and make sure it is installed both on the server Data Pump processes on, and the end user's machine. We were using an obscure font that came with Monarch that non of the user PCs had.