+ Start a Discussion
JimmyC1228JimmyC1228 

Checking if a Refresh Has Finished

I am using the Office Edition Excel Add-in, and I have some code to refresh reports in a workbook and then sort them.  When I run the program, the ouput is not correctly sorted.  I think this is due to the sort process starting before the refresh finishes.  Does anybody know if there is a method to check if a refresh has finished before proceeding?  If not, does anyone know how else I might avoid this problem.  Thanks.
StefanStefan
Right mouse click on result
Select Data Range properties
Unselect Enable background refresh