I have a Macro in an excel sheet that selects a value in a slicer, I had a pivot which was converted to OLAP. When selecting a value in the slicer there is a short period of time where all the cells display ‘########’ before the value is displayed. My trouble is. I have a macro which loops through these values and publishes them as PDF’s. All PDF’s as a result show “#######” in all the cells as when it is looping through the slicer values, it cannot delay the export. I have tried using the Application.Wait (Now + TimeValue("00:00:10")) but this pauses the workbook and does not allow events to continue in the background. So I had a little check online and come across this little piece of code.