REFRESH PIVOT TABLE

knudsent · Apr 8th, 2002, 04:14 PM

Last month, I had an Excel spreadsheet with 20 pivot tables within 10 separate worksheets. If I hit the refresh button on any one pivot table, all the tables refreshed. Today, I must hit the refresh button on each separate pivot table to do a complete refresh. I do not know what I did to make this change. Can anyone tell me what I possible did to modify the refresh capability?

brettvba · Apr 8th, 2002, 04:20 PM

not sure but just record a macro of you refreshing each pivot table and run the macro when ever you want to update the pivot tables.

Mark W. · Apr 8th, 2002, 04:30 PM

Originally, all the PivotTables were probably sourced from a single PivotTable (the one you were refreshing). You may have unwittingly created this configuration by making copies of the worksheet that contained your original PivotTable and then modified each according to your needs. Alternately, you could have explicitly sourced subsequent PivotTables by specifying "Another PivotTable" at Step 1 of 4 in the PivotTable wizard. Either way you subsequently changed the source of what was a dependant PivotTable.

You could remedy this situation by re-establishing the sourcing from a "master" PivotTable by pressing the PivotTable wizard's [ Back ] button to return to Step 1 and re-specifying the source. Or, you could use the Refresh All toolbar button (from the External Data toolbar) to refresh all PivotTables on the workbook.

[ This Message was edited by: Mark W. on 2002-04-08 15:31 ]

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

Apr 8th, 2002, 04:14 PM	#1
knudsent New Member Join Date: Apr 2002 Posts: 1	Last month, I had an Excel spreadsheet with 20 pivot tables within 10 separate worksheets. If I hit the refresh button on any one pivot table, all the tables refreshed. Today, I must hit the refresh button on each separate pivot table to do a complete refresh. I do not know what I did to make this change. Can anyone tell me what I possible did to modify the refresh capability?

Apr 8th, 2002, 04:20 PM	#2
brettvba MrExcel MVP Join Date: Feb 2002 Location: Christchurch New Zealand Posts: 1,030	not sure but just record a macro of you refreshing each pivot table and run the macro when ever you want to update the pivot tables.

Apr 8th, 2002, 04:30 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Originally, all the PivotTables were probably sourced from a single PivotTable (the one you were refreshing). You may have unwittingly created this configuration by making copies of the worksheet that contained your original PivotTable and then modified each according to your needs. Alternately, you could have explicitly sourced subsequent PivotTables by specifying "Another PivotTable" at Step 1 of 4 in the PivotTable wizard. Either way you subsequently changed the source of what was a dependant PivotTable. You could remedy this situation by re-establishing the sourcing from a "master" PivotTable by pressing the PivotTable wizard's [ Back ] button to return to Step 1 and re-specifying the source. Or, you could use the Refresh All toolbar button (from the External Data toolbar) to refresh all PivotTables on the workbook. [ This Message was edited by: Mark W. on 2002-04-08 15:31 ]