File Format & Compatibility

Fix Excel Form Control Cell Links Disappearing After Downloading a Workbook

Amos GikundaAmos Gikunda Nov 13, 2026 870 views

Question details

The user needs to determine why Excel Form Control option buttons lose their linked cells after an XLSX workbook is uploaded to a non-Microsoft repository, downloaded, and opened in Microsoft 365 Excel, and how to resolve or work around the issue.

Fix Excel Form Control Cell Links Disappearing After Downloading a Workbook
Product
Microsoft Excel, WPS Office Spreadsheets
Device & OS
not provided
Scenario
A user uploads an XLSX workbook containing Form Control option buttons with linked cells to a third-party repository, then downloads and opens it in Microsoft 365 Excel.
Observed behavior
The option buttons retain their linked cells in Excel 2010, but the cell links are missing after the workbook is downloaded and opened in Microsoft 365 Excel. Opening the file in an older Excel version restores the links.
Before you start

Before troubleshooting, record the original cell link for each option button in the working Excel 2010 copy so you can compare it after downloading. Also confirm whether the control is a Form Control by right-clicking it and checking that Format Control appears on the context menu.

Solution 1

Confirm the Control Type and Check the Cell Link in Microsoft 365 Excel

Use this when you first open the downloaded workbook and need to verify whether the option button still has a cell link.

1
Open the downloaded workbook in Microsoft 365 Excel

Start Microsoft 365 Excel, open the downloaded XLSX file, and select the worksheet that contains the option buttons.

2
Right-click the option button and choose Format Control

Right-click the option button. If Format Control appears, it is a Form Control; if Properties appears instead, it is likely an ActiveX control.

3
Check the Control tab for the Cell link field

In the Format Control dialog, open the Control tab and inspect the Cell link box to confirm whether it is blank or points to the expected cell.

Free Microsoft Office alternative

Use WPS Office Spreadsheets to Keep XLSX Workbook Controls Stable

WPS Office is a free, lightweight Office alternative that opens and saves Microsoft Excel XLSX workbooks with a familiar ribbon interface. It helps you work with form-style controls and linked cells without depending on a specific online repository or Microsoft 365 build.

Opens XLSX workbooks and lets you inspect or re-link Form Control option buttons without relying on Microsoft 365 downloads.Full compatibility with Microsoft Excel .xlsx, .xls, and .csv file formats.Free, lightweight Office suite with a familiar ribbon-style interface.Seamless migration path from Microsoft Excel for everyday spreadsheets and formatting.
microsoft office alternative - wps office

Frequently Asked Questions

Why do Excel Form Control cell links disappear after uploading and downloading an XLSX file?

This can happen when a workbook is processed by a non-Microsoft repository and then opened in Microsoft 365 Excel. Upload and download the file through OneDrive or SharePoint instead to compare whether the repository is causing the loss.

How can I check if my option button is a Form Control or an ActiveX control?

Right-click the option button in Excel. If the context menu shows Format Control, it is a Form Control. If it shows Properties instead, it is likely an ActiveX control.

What should I send to Microsoft Support if the cell links still disappear?

Provide the affected workbook, the repository used, the exact Excel version and build from File > Account > About Excel, and screenshots of the Format Control > Control tab showing the Cell link field.

Can using OneDrive or SharePoint prevent the cell link loss?

It can help identify whether a third-party repository is responsible. If the link remains after downloading from OneDrive or SharePoint but disappears through the other repository, use the Microsoft-hosted location for that workbook.

Does WPS Office support Form Control option buttons and cell links in XLSX files?

WPS Office Spreadsheets supports the XLSX format and provides editing for form-style controls, so you can open the workbook in WPS Office to verify or re-link the cell independently of Microsoft 365.