pivottables

Stono · Mar 18th, 2002, 12:53 PM

Hi.
I have a workbook containing five sheets, in every sheet there is a pivot table connected to an access database. How can I tell Access that after opining the Excel workbook to refresh all the sheets?
Thanks

IML · Mar 18th, 2002, 01:24 PM

Quote:

On 2002-03-18 11:53, Stono wrote:
Hi.
I have a workbook containing five sheets, in every sheet there is a pivot table connected to an access database. How can I tell Access that after opining the Excel workbook to refresh all the sheets?
Thanks

I feel answering questions actually asked is limiting :>, so here is another possible solution.

Under the pivot table menu in excel, choose options and check the Refresh on Open box under data options. Good luck.

Stono · Mar 18th, 2002, 01:38 PM

thanks for that . but i actually know about this option.. i am looking for a way to refresh when the cod run , just it not every time i want to open the workbook

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 18th, 2002, 12:53 PM	#1
Stono New Member Join Date: Feb 2002 Posts: 14	Hi. I have a workbook containing five sheets, in every sheet there is a pivot table connected to an access database. How can I tell Access that after opining the Excel workbook to refresh all the sheets? Thanks

Mar 18th, 2002, 01:38 PM	#3
Stono New Member Join Date: Feb 2002 Posts: 14	thanks for that . but i actually know about this option.. i am looking for a way to refresh when the cod run , just it not every time i want to open the workbook