I have an excel file with 3 different sheets having data connections to access tables. I need these to refresh through a macro instead of clicking on the DATA tab and then clicking on REFRESH ALL. Any ideas?

Also, should I uncheck the ENABLE BACKGROUND REFRESH on the connection properties?

Thanks in advance for assistance.