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.
|