I have a macro that updates pivot tables through and OBDC connection (ingress) every 2 minutes. The problem is that at 9am the host is doing a backup and terminates the connection until it is complete.
Run time error 1004
is there a way to stop the macro and try again at the next scheduled update?
Please Login or Register to view this content.
Bookmarks