Document Editing Problems

How to Fix the Update Labels Button Disabled in Word Mail Merge

Olivia Miller Sep 28, 2026 871 views

Question details

The user is unable to click the Update Labels button during a Word mail merge when using an Excel data source.

How to Fix the Update Labels Button Disabled in Word Mail Merge

Product: Microsoft Word
Device & OS: not provided
Scenario: Creating a labels mail merge using an Excel spreadsheet as the recipient list.
Observed behavior: The Update Labels button is greyed out or completely disabled in the ribbon, preventing the user from applying merge fields to all labels without reverting to the Mail Merge wizard.

Before you start

Ensure that your Excel spreadsheet is fully closed before using it as a data source in Word, as an open file can sometimes lock the connection and disable merge features.

Solution 1Recommended

Verify Document Type and Reconnect the Excel Data Source

The most common reason the button is disabled is that Word doesn't recognize the document as a Label merge, or the connection to the Excel file has dropped.

For the 'Update Labels' button to become active, Word must explicitly know that the current layout is intended for labels, and it requires an active link to a valid data source containing your records.

Set Document Type to Labels

Go to the 'Mailings' tab on the ribbon, click 'Start Mail Merge', and select 'Labels'. If a prompt appears asking for label dimensions, choose your preferred layout or click 'Cancel' if your layout is already correctly formatted.

Reconnect the Data Source

On the 'Mailings' tab, click 'Select Recipients' and choose 'Use an Existing List'. Browse your computer to locate and select your Excel spreadsheet again.

Check the Update Labels Button

Insert a merge field (such as First Name or Address) into the first label of your document. The 'Update Labels' button in the 'Write & Insert Fields' group should now be clickable.

Verify Document Type and Reconnect the Excel Data Source

Connection Restored: Once the button is active, clicking it will automatically copy the layout and merge fields from the first label to all other labels on the sheet.

Solution 2

Use the Step-by-Step Mail Merge Wizard

If the ribbon button remains unresponsive due to a temporary glitch, the built-in wizard forces Word to step through the label replication process.

Efficient Mail Merge Solution

Create Label Mail Merges Effortlessly in WPS Writer

WPS Office provides a highly compatible and intuitive Mail Merge feature. You can easily connect WPS Spreadsheets to WPS Writer to generate labels without dealing with connection glitches or disabled ribbon buttons.

1. Open WPS Writer: Launch WPS Writer and create a new document for your label layout.
2. Start Mail Merge: Navigate to the 'References' tab and click on 'Mail Merge' to reveal the dedicated merge toolbar.
3. Import Data Source: Click 'Open Data Source' and select your Excel or WPS Spreadsheet file containing the recipient list.
4. Insert and Update: Insert your desired Merge Fields into the first label cell, then simply click 'Update Labels' to instantly populate the rest of the sheet.

Fully compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Dedicated Mail Merge tab for intuitive, step-by-step document generation.Seamless data source connection without strict file-locking issues.Free, lightweight, and fast office suite for Windows, Mac, and Linux.

Frequently Asked Questions

Why is the Update Labels button greyed out in Word?

The button is typically greyed out if the document type is not explicitly set to 'Labels' in the Mailings tab, or if the connection to your data source (like an Excel file) has been lost, corrupted, or blocked by another application.

Can I update labels without the Mail Merge wizard?

Yes, as long as your document is correctly configured as a label merge and a valid recipient list is attached. You can then use the 'Update Labels' button directly from the Write & Insert Fields group on the Mailings ribbon.

Does the Excel file need to be closed during a mail merge?

Yes, it is highly recommended to keep the Excel data source closed while performing a mail merge in Word. Leaving the file open can cause read-write locks, preventing Word from successfully importing the data and thereby disabling merge features.

How do I make my mail merge labels show different names?

To show different names on each label, you need a '<<Next Record>>' rule. Clicking the 'Update Labels' button automatically inserts this rule before the merge fields on every label except the first one, instructing the program to pull the next name from your data source.

Document & File Issues