# Does Pivot/Preview Excel Export have merged cells in newer versions?

**URL:** <https://forum.reportserver.net/t/does-pivot-preview-excel-export-have-merged-cells-in-newer-versions/1850>\
**Category:** ReportServer (EN)\
**Created:** [June 7, 2025, 2:44am UTC](https://forum.reportserver.net/t/does-pivot-preview-excel-export-have-merged-cells-in-newer-versions/1850 "2025-06-07T02:44:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![zitot](https://forum.reportserver.net/letter_avatar_proxy/v4/letter/z/e47774/32.png) [@zitot](https://forum.reportserver.net/u/zitot)\
**Post date:** [June 7, 2025, 2:44am UTC](https://forum.reportserver.net/t/does-pivot-preview-excel-export-have-merged-cells-in-newer-versions/1850/1 "2025-06-07T02:44:09Z")

</div>

i.e. if we have a product category, and it takes 5 rows, like this:

```auto
Region Category Product Line Store Quantity Sold
-------------------------------------------------------------------
West Electronics TV Store 01 12
                                          Store 02 9
                         Fridge Store 01 7
                                          Store 03 11
           Groceries Chocolates Store 01 25
                                          Store 02 18
                         Cereals Store 02 10

East Electronics TV Store 01 14
                         Fridge Store 04 6
```

In excel, it would show everything on every row, if i select Excel-Export while in Pivot Preview, on Report server 3.x.x

```auto
Region Category Product Line Store Quantity Sold
-------------------------------------------------------------------
West Electronics TV Store 01 12
West Electronics TV Store 02 9
West Electronics Fridge Store 01 7
West Electronics Fridge Store 03 11
West Groceries Chocolates Store 01 25
West Groceries Chocolates Store 02 18
West Groceries Cereals Store 02 10
East Electronics TV Store 01 14
East Electronics Fridge Store 04 6
```

I guess I can get around this with a jxls template, using mergeCells, but that’s a little tricky and harder to do than visually dragging around cells until you get the order you want in pivot mode.

i was mostly just playing around with the pivot/preview mode today since I never used it. Originally i will write the jxls template but wasn’t sure if it supported that natively.

---

<div class="post-metadata">

**Author:** ![IF\_Eduardo](https://forum.reportserver.net/letter_avatar_proxy/v4/letter/i/94ad74/32.png) [@IF\_Eduardo](https://forum.reportserver.net/u/IF_Eduardo)\
**Post date:** [June 10, 2025, 11:00am UTC](https://forum.reportserver.net/t/does-pivot-preview-excel-export-have-merged-cells-in-newer-versions/1850/2 "2025-06-10T11:00:31Z")

</div>

Hi zitot,

please try the newest ReportServer. ReportServer 3.x.x is not supported.

In the current release, I have this:  
[![](https://i.ibb.co/qYGv1mqW/Bildschirmfoto-2025-06-10-um-12-58-35.png)](https://ibb.co/v45SzLyQ)

and its Excel export:  
[![](https://i.ibb.co/xSFB19dY/Bildschirmfoto-2025-06-10-um-12-58-43.png)](https://ibb.co/MDBtcwQf)

Regards,  
Eduardo
