I know that this is a relatively older thread, and apologies for reopening it, but I have a similar problem to this one with a pivot table I've created...
It used to be a straight table, but there were a lot of dimensions (24), and it was making the screen too large.
I needed it to have a horizontal scroll bar, but of course, you can't really have a horizontal scroll bar on a straight table, but i found a way of doing it by turning it into a pivot table, and leaving 10 dimensions, and then turning the rest into expressions.
A scroll bar now appears, but it does not preserve its position (even when the check box in the 'Layout' tab is ticked - the table also has a vertical scroll bar, which works fine with that option ticked).
This is my problem. I need my horizontal scroll bar to preserve it's position too.
The only way I have managed it is to detach the pivot table. However, when the document is reloaded, or just reopened, the table is attached again, and the scroll bar resets.
Can anyone help me with this?