Refreshing a Pivot table

[mhubbard]

I am having a problem with a pivot table in Access. When the table changes. The pivot table continues to show old data. Is there any way to Refresh the pivot table without going into excel to do that?
Thanks!

 

[llkhoutx]

Rerun the cross-tab (pivot table) query each time the underlying table changes.

 

[mhubbard]

The Pivot table (which I created under the forms tab) runs off a table. So there really isn't any way to rerun the query. I even changed the data source to a query instead, but it gives me old data. The only way I can refresh it is to open excel and refresh data manually.

 

[llkhoutx]

You're obviously not refreshing.

Surely you're not manually creating a pivot table, when the cross-tab query is available.

How are you building the pivot table?

 

[mhubbard]

I am going into the forms tab and using the 'Pivot table wizard'

 

[nightwalker]

pivot refresh

pivot table just links to Excel through OLE and the refresh event doesnt occur in Access but in Excel ... this is based on help browsing i did on access97 ... i am tryin to find some other wayu but i believe that has to be in excel to do that automatically ...
walker

 

[nightwalker]

Re: pivot refresh

the options... dialog box on the pivot table with the "Refresh on Open" option
if this is not what u r lookin for lemme know
thanks
walker