Submit a question to our community and get an answer from real people.
Submit

Name two ways in which Excel automatically refreshes a connection.

Report as

One of the ways that Excel automatically refreshes a connection is when you open the workbook. The other way is at regular intervals. This is activated when you select the Refresh every check box from Usage tab under Connection Properties. You will also be required to set the number of minutes when it should refresh. You can read more about it at http://office.microsoft.com/en-001/excel-help/refresh-connected-imported-data-HP010087045.aspx#BMautomatically_refresh_data_when_a_wor.

Helpful Fun Thanks for voting Comments (0)
Report as
Add a comment...
Do you have an answer?
Answer this question...
Did you mean?
Login or Join the Community to answer
Popular Searches