Try making "Use Excel Formatting" default for your system. This can be done by:
Select Use Excel Formatting and Save as default ("Drop Down button on OK button).
Thanks for the pointer, I try that and still the formating is not carried over on cascaded worksheet, does this work for you on 184.108.40.206 smartview?
Try in 220.127.116.11. It did.