You need to sign in to do that
Don't have an account?
JimmyC1228
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.
Stefan
Right mouse click on result
Select Data Range properties
Unselect Enable background refresh