In MS Word, when dealing with linked data fields from Excel, how can a user ensure that data updates do not happen automatically upon opening the document, but rather require a manual refresh command?

Answer as guest — Start Free Practice Test to earn Practice PointsHow to earn pointsAsk a question+3Answer a question+1Someone answers yours+1Your Q gets upvoted+1Pioneer bonus (first 5)+5, ask questions & climb the leaderboard!

A By setting the Excel file to Read-Only mode before opening the Word document.
B By modifying the link properties in the Edit Links dialog box to select manual update instead of automatic update.
C By disabling the macro security settings in the Trust Center.
D none of these

Show answer and explanation

Answer: B. By modifying the link properties in the Edit Links dialog box to select manual update instead of automatic update.

• Answer: B
• Explanation: Through the "Links to External Files" or "Edit Links" dialog box in Word, users can change the update trigger configuration for individual OLE connections from "Automatic Update" to "Manual Update".

Answering after opening this box earns no Practice Points.

Rules for asking and answering

In MS Word, when dealing with linked data fields from Excel, how can a user ensure that data updates do not happen automatically upon opening the document, but rather require a manual refresh command?

More questions like this