#1
|
|||
|
|||
opening a pivot
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 |
#2
|
|||
|
|||
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, Quote:
|
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
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 |
#5
|
|||
|
|||
thanks that works
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Create PIVOT chart using few rows in pivot table | Santhosh_84 | Excel | 1 | 08-31-2015 06:22 AM |
Opening a word doc without opening all attached links/reference | Nicobisgaard | Word | 9 | 07-21-2015 08:49 AM |
Pivot table help | TishyMouse | Excel | 2 | 04-27-2012 10:19 AM |
Pivot Table | Karen615 | Excel | 5 | 08-03-2011 10:46 AM |
Pivot Question | rejubinu@gmail.com | Excel | 1 | 01-21-2011 02:25 PM |