Refresh Pivot Table???

[mahmudich]

Hi everyone!

The question I’m gonna ask I’ve already seen before, but nobody knew an answer, so I’ll try again: Is there any ways to refresh a Pivot Table without going in to one and pressing refresh button?

Thank for reading…

 

[mahmudich]

COME ON GUYS!
SOMEBODY SHOULD KNOW IT!!!

 

[nightwalker]

pivot refresh

pivot table just links to Excel using OLE but Refresh event has to happen in Excel ... not in access ... This is based on the help on Access 97 ... i havent found a way to refresh in excel automatically ...
sorry

 

[mahmudich]

got it

I've worked it out! If anybody incounting the problem feel free to reply

 

[nightwalker]

Re: got it

I didnt knew there was a way ... i am having the problem but havent found the solution yet ... could you please lemme know how did you solve that ...
thanks ...
walker

 

[nightwalker]

Re: Re: got it

is it the options... dialog box on the pivot table with the "Refresh on Open" option that you are talking about or is there any other way ...
thanks
walker

 

[mahmudich]

the solution

The thing is that the solution is DO NOT use the pivot table. What I used is MS Excel to display information and MS Query to create a query. By selection in MS Excel option: Data Range Properties you can set Refresh Data On File Open. That’s it.