View Single Post
  #1   Report Post  
dolph
 
Posts: n/a
Default refresh pivot tables through a macro

Hi all,

I'm trying to create a macro to update pivot tables with a macro. but
when I create it and then try to run it, I receive the message: It'
impossible to find the propriety Pivot tables for the class Worksheet.
the Macro is:
"Sheets("Inserimento Dati").select
Range("H24").Select
ActiveSheet.PivotTables("tabella_pivot1").RefreshT able"

The system is Excel 2003 in XP. I did a similar macro in WIN 98 and it
worked, but it used a PivotTables wizard that does not work any more
in XP.

Thanks a lot in advance, hope I've been clear enough.