Permission & Access Issues

Fix Change Source Disabled for Links in a Protected Excel Sheet

Chanuka Geekiyanage Oct 16, 2026 868 views

Question details

Users are unable to use the Change Source option in the Edit Links dialog because it is disabled when the Excel worksheet is protected, and they need a workaround.

How to Fix Change Source Disabled for Links in a Protected Excel Sheet

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to update or change external link sources in a shared or protected workbook.
Observed behavior: The Change Source button within the Edit Links dialog is grayed out and cannot be clicked while worksheet protection is active.

Before you start

Before making changes, verify that you have the correct password to unprotect the worksheet, as modifying external links requires temporarily lifting sheet protection or administrative access.

Solution 1Recommended

Temporarily Unprotect the Worksheet to Change the Source

The most straightforward workaround is to temporarily remove the sheet protection, update your external links, and then re-apply the protection.

Excel does not have a built-in permission setting that allows users to use the Change Source feature while a worksheet remains protected. The most reliable method is manually unprotecting the sheet for authorized users.

Unprotect the Worksheet

Navigate to the Review tab on the Excel ribbon and click on 'Unprotect Sheet'. Enter the password if prompted.

Access Edit Links

Go to the Data tab and click on 'Edit Links' in the Queries & Connections group.

Change the Source

Select the linked file you want to update, click the 'Change Source' button, and browse for the new source file.

Re-protect the Worksheet

Return to the Review tab, click 'Protect Sheet', set your desired permissions, and re-enter your password to secure the sheet.

Temporarily Unprotect the Worksheet to Change the Source

Administrative Control: This method is best suited for workbook administrators or users who can be trusted with the unprotect password.

Solution 2

Create a VBA Macro to Manage Links Securely

If end-users frequently need to change links, you can write a VBA script that handles the process automatically without permanently exposing the unprotected sheet.

Solution 3

Redesign the Workbook Architecture

Restructure your Excel files so that external references update automatically without requiring users to access the Edit Links dialog.

Free Microsoft Office alternative

Manage Spreadsheets Easily with WPS Office

If you are frustrated by strict Microsoft Office permission barriers or workbook management complexities, consider switching to WPS Office. It is a free, lightweight, and user-friendly alternative that ensures a seamless migration for all your daily tasks.

1. Download and Install: Get the free WPS Office suite from the official website and follow the quick installation prompts.
2. Open Your Workbook: Launch WPS Spreadsheet and seamlessly open your existing .xlsx or .xls files without losing any formatting.
3. Manage Permissions: Use the built-in Review tools to protect or unprotect your sheets and manage external links easily.

100% fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Advanced workbook protection and external link management features.Free and lightweight application that runs smoothly without slowing down your computer.Familiar user interface that requires zero learning curve to master.

Frequently Asked Questions

Is there a specific permission to allow Change Source in protected Excel sheets?

No, Excel does not offer a built-in granular permission that lets users edit links or change sources while worksheet protection is active.

Why does Excel disable Edit Links on protected sheets?

Excel restricts the Change Source feature in protected sheets to maintain data integrity and prevent unauthorized modifications to external references that could break formulas.

Can I use VBA to change the source without giving users the unprotect password?

Yes, you can write a VBA macro that contains the password within the code. The macro can unprotect the sheet automatically, prompt the user to update the link, and immediately re-protect the sheet.

Document & File Issues