cb or macro to refresh data in pivot table form

[luvthisboard!]

Hi

can someone tell me how to write either a macro or a command button to allow users to refresh the data in a pivot table form so that they don't actually have to go into the pivot table in the excel format.

many tks

 

[nightwalker]

pivot refresh

what i have found and i believe is that Access pivot table uses OLE to only connect to Excel and the refresh event is in Excel and not in access ... i havent found but am tryin to find a way to control refresh event of excel from access or a way to automatically generate it ... this info is based on help menu browsing for access97 ...
thanks
walker

 

[nightwalker]

Re: pivot refresh

the options... dialog box on the pivot table with the "Refresh on Open" option
if this doesnt help lemme know
thanks
walker