title: Wait time after change slicer in power pivot
body: <p>I have a powerpivot table and one slicer with several values. I have a macro that loops over my slicer and makes a copy of the data and paste the values in another excel</p>
  
  <p>After any data update when I change the slicer Excel takes some time to query or recalculate values and in the cells appear  "#######" during some seconds until the the new data are loaded.</p>
  
  <p>This is a problem for my macro because it is copying this characters instead of the values. I have try two approaches to give more time to the loading process: </p>
  
  <ul>
  <li>Create a Wait of 5 seconds that is more than enough before copy-pasting the data</li>
  <li>Put a Msgbox to stop the copy pasting.</li>
  </ul>
  
  <p>None of them work. Both of them seems to interrupt the loading process that I though will run in the background.</p>
  
  <p>Is there any event in vba that notifies me when the data are loaded?</p>