PivotTables - Refresh Problem

[Cogivina2004]

My pivot table does not refresh after I run the macro. However, if I put a stop in the marco, and run it manually..the pivot table get updated. I've tried many times but I could not figure it out how this is possible.

......
Sheets("Sheet1").select
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
......

Thanks.

 

[Cogivina2004]

I have about 10 pivot tables in this program. They all refresh when the data is updated, except for the one I mentioned. All the field names are the same during the process.

 

[johnwm]

Welcome to Tek-Tips. To get the best answers read faq222-2244 which gives some guidelines on overall forum usage.

At the top of the page is a Find a Forum search box. You will do better with VBA specific questions in the VBA forum forum707 as this forum is specifically for VB5/6 issues

________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'If we're supposed to work in Hex, why have we only got A fingers?'

http://www.essexsteam.co.uk

for steam enthusiasts