Hello expert;

I would like to create a situation when a pivot is open, the data in the pivot gets refreshed automatically without clicking on the refresh button. Is it possible. Thank you

You would need to use a macro for this.

Here is one option, but no matter what, you have to click something.

http://chandoo.org/wp/2011/09/19/ref...-pivot-tables/

If you can explain,

maybe there are other options.

Hi;

SO i would like the data in the pivot refreshed when the user opens up the pivot without clicking any button or the refresh all. thank you

Perhaps http://www.techonthenet.com/excel/pi...n_open2010.php

or

https://stackoverflow.com/questions/...sing-vba-macro

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

thanks that works