Fix Excel Form Control Cell Links Disappearing After Downloading a Workbook
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.

- 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 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.
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.
Start Microsoft 365 Excel, open the downloaded XLSX file, and select the worksheet that contains the option buttons.
Right-click the option button. If Format Control appears, it is a Form Control; if Properties appears instead, it is likely an ActiveX control.
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.
Test the Workbook Through OneDrive or SharePoint to Isolate the Repository Issue
Use this when the cell link is missing after using a third-party repository and you need to determine whether the repository causes the loss.
Collect Diagnostic Details and Report to Microsoft Support
Use this when the cell link still disappears even after testing a Microsoft-hosted location, or when you need official confirmation from Microsoft.
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.

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.





