Saving Layout of a Pivot Table that changed via Drag and Drop

[#1]

I am trying to save a pivot table layout, my users are building via Mouse Drag and Drop. (e.g. expressions on vertical axis, dimensions on horizontal). I save all Dimensions and Expressions in QV Variables with the help of a QV Bookmark. Whenever my users are reloading this Bookmark, their saved Pivot Table is rebuilded via VB Macros ( i read out the QV Variables).

So far so good. But if they change dimensions and expressions via Mouse Drag and Dropm reloading will not bring back their (changed) layout.

Any suggestions how to save a Drag and Drop Layout in a Bookmark.

Thanks for your help!

[#2]

Any suggestions?

[#3]

Hi kalle,

When you create your bookmark, do you have "Include Layout State" checked?

Andy Rizzuto
www.NxGenConsulting.com

[#4]

Hi Andy,

thanks for you answer. I tried to check that option, but i does not work, because i rebuild the pivot table every time. As far as the dimensions and expressions in the pivot table has changed, "Include Layout State" is not working anymore.

[michael_anthony]

Hi Kalle,

Do you give the user the option to resave the bookmark after they've moved the dimensions around? If you save to the QV variables first time why not do it again. Or is there some other problem then that happens?

One other option would be to use collaboration object - may even be able to use macro to create it for the user and attach to the bookmark so it can be recalled later. Don't know if it that is possible, but sounds like your VB macro skills are already there.