Fix Excel AutoFill and AutoComplete in a Shared Workbook
Question details
Restore or troubleshoot cell-value AutoComplete and AutoFill in a shared Excel 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.
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.
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.
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.
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.
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.
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.

Check Excel AutoComplete and fill handle settings
Use these checks if the features still do not work or the workbook does not use legacy sharing.
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.

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).




