When creating a pivot table, the heading defaults as a merged cell across the worksheet columns. The merged cell prevents the pivot table items from being modified (adding cached fields gives error message: cannot modify part of merged cell).
What is the easiest way of including the heading, but removing the merged cell formatting ?This message has been edited. Last edited by: Stephen,
it seems that this post is about the same
Heading in pivot table
which says that its not the issue of webfocus but Microsoft.....as we can not do anything...
still if u able to find out the solution then pls keep us updated....
WebFocus7.6.2, WebFocus 7.1.1,Windows
HTML, PDF and Excel
We came up with a passable workaround. Setting the column span to 1 and aligning to body allows for the pivot table to be modified.
|Powered by Social Strata|