Refreshing multiple forms and pivot tables

torontosnow · May 1st, 2002, 06:59 AM

Hi, I am very new to Macro Programming and this is my first attempt. I am hoping someone here can help me. Basically, I have multiple worksheets, and muliple pivot tables, which I would like to be refreshed when the user either opens the workbook, or when he clicks on something in the book itself. I did a search already and saw this sort of question has been asked before, but I did not understand the solution since I am very new. Can somone explain or give me an example as well? Thanks for your help.

torontosnow · May 1st, 2002, 08:24 AM

bump

geolefty · May 1st, 2002, 10:39 AM

Within a pivot table right click and go to table options.

Check the box for "refresh on open" (towards the lower left)

this will refreh the pivot tables when the file is opened.

EdE · May 1st, 2002, 11:24 AM

The macro line is something like this:
Set pvtTable1 = Worksheets("Mtr1").Range("d10").PivotTable
pvtTable1.RefreshTable

Where d10 is the position of the pivottable. You will need an IF statement before depending on what you want to trigger it.

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

May 1st, 2002, 06:59 AM	#1
torontosnow New Member Join Date: Apr 2002 Posts: 2	Hi, I am very new to Macro Programming and this is my first attempt. I am hoping someone here can help me. Basically, I have multiple worksheets, and muliple pivot tables, which I would like to be refreshed when the user either opens the workbook, or when he clicks on something in the book itself. I did a search already and saw this sort of question has been asked before, but I did not understand the solution since I am very new. Can somone explain or give me an example as well? Thanks for your help.

May 1st, 2002, 08:24 AM	#2
torontosnow New Member Join Date: Apr 2002 Posts: 2	bump

May 1st, 2002, 10:39 AM	#3
geolefty Board Regular Join Date: Mar 2002 Location: CA Posts: 180	Within a pivot table right click and go to table options. Check the box for "refresh on open" (towards the lower left) this will refreh the pivot tables when the file is opened.

May 1st, 2002, 11:24 AM	#4
EdE Board Regular Join Date: Apr 2002 Location: A Mile High!! Posts: 230	The macro line is something like this: Set pvtTable1 = Worksheets("Mtr1").Range("d10").PivotTable pvtTable1.RefreshTable Where d10 is the position of the pivottable. You will need an IF statement before depending on what you want to trigger it.