MS Report Viewer 2008 Export to excel merged cells problem

We are using MS Report Viewer for exporting Reports to Excel, now we have a problem when trying to sort data, its reporting error that there are merged cells and it can't be sorted. So is there a way to disable cell merging when exporting to excel?

Thanks in ad开发者_如何学Pythonvance.

---

To my knowledge there is no way to turn this off. However, I only notice it being a problem when I use page headers or page footers. This is why often times I'll make page headers and footers optional in my reports to avoid the Excel merge cell issue.