Hi,
Did you see the code behind sheet1? It will only trigger if you change one of the cells between G16 and H20. If you are entering values below that in column H then change the 20 to the last row you will enter data into.
Other than that - if you are already running VBA code to pull in data, simply add a line of code after it pulls stuff in of
and that will update the Pivot Table.
ActiveWrokbook.RefreshAll
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
what if the range h16:h20 (this is the main data, wont be adding anymore data) remain unchange? Just only the value inside it will change every 10 seconds? Exp. The value of EurUsd is 1.2345 right now, the next second it change to 1.2350. But the value in pivot table will not change to 1.2350 unless i press the refresh on excel.Originally Posted by MarvinP
Hi,
Did you see the code behind sheet1? It will only trigger if you change one of the cells between G16 and H20. If you are entering values below that in column H then change the 20 to the last row you will enter data into.
Other than that - if you are already running VBA code to pull in data, simply add a line of code after it pulls stuff in of
and that will update the Pivot Table.ActiveWrokbook.RefreshAll
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks