pivotable excel2000 macro

[chaim rozent]

i want to chack (not to refresh) if a pivotable is already refreshed.
i have to make some operations before the refreshing
so the macro must identify if the pifotable was refreshed
or not
can you help me to build such macro?

thank you
rozent



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[BrianB]

I cannot see how this could be done because Excel has no way of knowin
if the base data has been changed or not.

1. We can check the last refresh time with something like :-

Code
-------------------

Set pvtTable = ActiveSheet.PivotTables(1)
dateString = Format(pvtTable.RefreshDate, "dd/mm/yyyy hh:mm:ss")
MsgBox dateString

-------------------



2. You could set up your own variable and change it if *you* d
something to the base data within the macro :

Dim PivotIsRefreshed as Boolean
PivotIsRefreshed = Fals