Pivot table issue

[#1]

I have a pivot table that when it is expanded that when you try to scroll down it then pops back up to the top. It also does it if you are trying to scroll to the right at the bottom. the only way it works is if I collapse the table and then only expand what I want to look at. Any clues?

[#2]

Can you upload the qv file or atleast post an image of the chart ?

Regards

Eraaj

[#3]

If you go to the scrap details and if you have any data in the pivot table and you need to scroll up or down or side to side you can pull it down and and it will jump back to where it was.

Thanks for looking at this.

Susan

[#4]

I was unable to see any scroll bars in your pivot chart (see attached img).

That being said, you could click chart properties and under layout tab, uncheck the 'allow move/size' under options.

Regards

Eraaj

[#5]

Susan,

Look in the properties of your pivot table under the tab "Layout". Make sure that "Preserve Scroll Position" is checked.

HTH,

Stephen

[#6]

Thank You that did the trick.

Susan