Question

When connecting to Access data in Excel 2013 which of the following is NOT
one of the standard options for Refresh control in the Connection Properties
dialog? Choose one.
2
Refresh data when opening the file
Enable background refresh
Refresh this connection in Refresh All
-
Refresh data when closing the file
Submit answer​

Answer 1

hi friend,

here is your answer

please follow me so that I can give you more answers which will help you

Answer:

it's explained below

Explanation:

Update only the selected data Press ALT+F5, or on the Data tab, in the Queries & Connections group, click the arrow under Refresh All, and then click Refresh.

Update all data in the workbook Press CTRL+ALT+F5, or on the Data tab, in the Queries & Connections group, click Refresh All.

hope it helps

if helps please follow me