How can a pivot table refresh data automatically while the file is open and
the data is changed without me having to hit the refresh data button?

On Feb 25, 4:11 pm, pmyers...@hotmail.com
<pmyers123hotmail...@discussions.microsoft.com> wrote:
> How can a pivot table refresh data automatically while the file is open and
> the data is changed without me having to hit the refresh data button?

Hi pmyers123,
you probably need a VBA macro. Have a look at http://www.ozgrid.com/VBA/pivot-table-refresh.htm

Cheers Michael

You can refresh your pivots upon opening your file without having to plug in a macro.

Go to your Pivot table options, you should see a Data tab, just check the Refresh data when opening the file checkbox.



> On Wednesday, February 25, 2009 10:11 AM pmyers123hotmailco wrote:

> How can a pivot table refresh data automatically while the file is open and
> the data is changed without me having to hit the refresh data button?


>> On Saturday, February 28, 2009 2:37 AM Michael.Tarnowski wrote:

>> Hi pmyers123,
>> you probably need a VBA macro. Have a look at http://www.ozgrid.com/VBA/pivot-table-refresh.htm
>>
>> Cheers Michael


>> Submitted via EggHeadCafe
>> Microsoft .NET DataBase Access For Beginners
>> http://www.eggheadcafe.com/training-...y-Samples.aspx