96. Breaking workbook links

Breaking Workbook Links

**Breaking Workbook Links** in Excel converts linked data into static values. This is useful when you no longer want the destination workbook to update dynamically from the source workbook.

Steps to Break Workbook Links

• Step 1: Open the destination workbook that contains links to the source workbook.
• Step 2: Go to Data → Edit Links.
• Step 3: Select the links you want to break and click Break Link.
• Step 4: Confirm the action. The linked data will now be static.

Interactive Example: Breaking Workbook Links

Destination Workbook

Item	Stock (Linked)
Laptop	50
Mouse	200
Keyboard	100

Click "Break Links" to convert linked data into static values.

This example demonstrates how to break links in a destination workbook to make the linked data static.