View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LCK[_2_] LCK[_2_] is offline
external usenet poster
 
Posts: 8
Default QueryTable Last Refresh Date?

Hi

You can obtain the last time a Pivot Table was refreshed using:
Activecell.pivottables(1).RefreshDate

Do QueryTables have a property to read the last time they were
refreshed?

Thanks