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
--
Brian
-----------------------------------------------------------------------
BrianB's Profile:
http://www.excelforum.com/member.php...tinfo&userid=5
View this thread:
http://www.excelforum.com/showthread.php?threadid=27410