Office Compatibility Issues

Fix Excel AutoFill and AutoComplete in a Shared Workbook

Nimra MalikNimra Malik Nov 18, 2026 869 views

Question details

Restore or troubleshoot cell-value AutoComplete and AutoFill in a shared Excel workbook.

Fix Excel AutoFill and AutoComplete in a Shared Workbook
Product
Microsoft Excel
Device & OS
not provided
Scenario
A user wants to complete cell values or fill a series while editing a shared workbook.
Observed behavior
AutoComplete or AutoFill may stop working after the workbook is shared, potentially because of legacy sharing limitations or Excel settings.
Before you start

Check whether the workbook uses Excel's legacy Shared Workbook feature or modern co-authoring. Ask other editors to save and close the file before changing legacy sharing settings.

Solution 1Recommended

Stop legacy sharing and switch to modern co-authoring

Use this approach if the workbook uses legacy sharing and you still need multiple people to edit it.

Legacy shared workbooks have editing limitations that modern co-authoring avoids. Stopping legacy sharing can remove change history, so review any history you need before proceeding.

1
Check legacy sharing

In Excel, open the workbook and select Review > Share Workbook (Legacy). If the command is hidden, add Share Workbook (Legacy) through File > Options > Quick Access Toolbar.

2
Stop legacy sharing

On the Editing tab of the Share Workbook dialog, clear the option that allows changes by more than one user, then select OK and save the workbook.

3
Test the features

Type a value that matches an existing text entry in the same column to test AutoComplete. To test AutoFill, select a cell and drag its fill handle across adjacent cells.

4
Share for co-authoring

Save the workbook in a supported format such as .xlsx to OneDrive or SharePoint, then select Share and invite editors. Participants need a version of Excel that supports co-authoring.

Stop legacy sharing and switch to modern co-authoring
If sharing cannot be turned off: You may need to remove shared workbook protection or obtain the required permissions before changing the legacy sharing setting.
Free Microsoft Office alternative

Work with Excel-compatible spreadsheets in WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheets and continue working with your existing spreadsheets; it does not change Excel's legacy sharing settings.

Use spreadsheet fill tools for repetitive entries and seriesOpen and edit Microsoft Excel formats, including XLSX and XLSMove from Excel to a familiar spreadsheet interfaceUse a free, lightweight Office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where is the AutoComplete setting in Excel?

Go to File > Options > Advanced and select Enable AutoComplete for cell values under Editing options.

Why can't I see Share Workbook on the Review tab?

Excel may hide the legacy command. Go to File > Options > Quick Access Toolbar and add Share Workbook (Legacy), then open it from the toolbar.

Does enabling AutoComplete also enable the fill handle?

No. In File > Options > Advanced, select Enable fill handle and cell drag-and-drop separately from Enable AutoComplete for cell values.

Can people still edit together after I stop legacy sharing?

Yes. Save the workbook as a supported file such as .xlsx in OneDrive or SharePoint, then use Share to invite editors with co-authoring-compatible versions of Excel.

Will stopping legacy sharing affect change history?

It can remove the legacy shared workbook's change history. Review any history you need before turning off sharing through Share Workbook (Legacy).