Fix Excel Linked Buttons Not Working in Frozen Top Rows
Question details
The user needs to fix an issue where linked buttons and shapes in Excel become unresponsive when positioned over frozen top rows or columns.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Clicking linked buttons or shapes located over frozen panes to trigger actions or navigation within a local workbook.
- Observed behavior
- The linked buttons and shapes do not respond to clicks when placed over frozen rows, often due to bugs in recent Microsoft 365 updates.
Before troubleshooting, verify your current Office build number in the Account settings and check if unprotecting your worksheet restores the button functionality.
Roll Back or Update Your Microsoft 365 Build
Since this bug is tied to specific recent Office 365 builds (such as the 23xx series), reverting to a stable previous version or installing the latest patch can restore button functionality.
Many users have found that Microsoft 365 Enterprise versions in the 23xx range (like build 17029.20108) experience this bug, while older versions (like 2206 or 2204) process buttons correctly.
Open Excel, click on 'File', and select 'Account'. Look under 'About Excel' to identify your current version and build number.
Click 'Update Options' and select 'Update Now' to see if Microsoft has released a patch that fixes the frozen pane button bug.
If no fix is available, use the Microsoft Office Deployment Tool to downgrade your Excel version to a stable release, such as version 2206 (build 15330.20230).
Temporarily Unfreeze Panes
As a quick workaround, unfreezing the rows and columns can make the buttons clickable again while you wait for a permanent software patch.
Contact Microsoft Support
If rolling back the version doesn't help or if the issue is specific to a certain device like a Surface tablet, opening a ticket with Microsoft Support is recommended.
Try WPS Office for Flawless Spreadsheet Navigation
If Microsoft Excel bugs with frozen panes and unclickable buttons are disrupting your workflow, WPS Office provides a highly compatible, stable, and free alternative.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for your operating system.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing .xlsx file containing the frozen rows and linked buttons.
- 3. Test the Buttons: Click your linked shapes and buttons within the frozen panes to experience smooth, bug-free navigation.
Frequently Asked Questions
Why do shapes stop working when rows are frozen in Excel?
This is often caused by a known bug introduced in certain Microsoft 365 build updates (such as the 23xx series). The update interferes with how Excel registers mouse clicks on objects that are overlaid on frozen panes.
Can sheet protection cause linked buttons to become unresponsive?
Yes. If a worksheet is protected and the 'Edit Objects' permission is not explicitly checked during the protection process, buttons and shapes cannot be clicked, triggered, or modified.
How do I check my current Excel build number?
Open Excel, click on 'File' in the top-left corner, and select 'Account'. Your current version and specific build number will be displayed on the right side under the 'About Excel' section.
