Audra wants the workbook to always display the most current values from a text file used when importing external sales data.What is the advantage of editing the properties of the connection versus editing the properties of the external data range?
A)The choices are applied to all of the external data ranges that use that connection.
B)The choices are applied only to the current workbook.
C)The choices are only applied the first time the workbook is opened after the properties have been changed.
D)There is no advantage-it would be better to edit the properties of the external data range.

Question

Quizplus · Accepted Answer

Editing the properties of the connection ensures that the changes are applied to all external data ranges that use that connection, providing consistency across multiple worksheets or workbooks. Editing the properties of the external data range only applies to that specific range within the workbook.

Audra Wants the Workbook to Always Display the Most Current