Refresh Hiding Sheet

nc · May 15th, 2002, 02:52 AM

Hi all,
How can i run a macro which refreshes a pivot table in a hidden worksheet? Also, how do i hide a sheet? Any related codings r appreciated. Thanks.

Colo · May 15th, 2002, 03:21 AM

Hi, Here is a smple. Please try this.

Sheets("Pvt").Visible = False

You will need to modify the PivotTablest name.

' refreshes a pivot table in a hidden worksheet
Sheets("Pvt").PivotTables("pvt1").RefreshTable

Also you will need to modify the sheet name.
'How to hide a sheet
Sheets("Pvt").Visible = False

nc · May 15th, 2002, 07:25 PM

thanks! Colo.
it's working fine.

nc

May 15th, 2002, 03:21 AM	#2
Colo MrExcel MVP Join Date: Mar 2002 Location: Kobe, Japan Posts: 1,420	Hi, Here is a smple. Please try this. Sheets("Pvt").Visible = False You will need to modify the PivotTablest name. ' refreshes a pivot table in a hidden worksheet Sheets("Pvt").PivotTables("pvt1").RefreshTable Also you will need to modify the sheet name. 'How to hide a sheet Sheets("Pvt").Visible = False __________________ Regards, Masaru Kaji aka Colo - Ex Microsoft MVP Since 2004 -2009

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

May 15th, 2002, 02:52 AM	#1
nc New Member Join Date: May 2002 Posts: 23	Hi all, How can i run a macro which refreshes a pivot table in a hidden worksheet? Also, how do i hide a sheet? Any related codings r appreciated. Thanks.

May 15th, 2002, 07:25 PM	#3
nc New Member Join Date: May 2002 Posts: 23	thanks! Colo. it's working fine. nc