Fix Find and Replace or Sort in Excel Files from Google Drive
Question details
The user needs to restore Find and Replace or Sort functionality in Excel files downloaded from Google Drive.

- Product
- Microsoft Excel and Google Drive
- Device & OS
- not provided
- Scenario
- An Excel workbook downloaded from Google Drive needs to be searched, edited, or sorted.
- Observed behavior
- Find and Replace or Sort may not work as expected, potentially because of workbook content, formatting, compatibility, or an Excel add-in.
Open the downloaded file in Excel and note whether the problem affects Find and Replace, Sort, or both. Check whether the worksheet is protected and whether the affected range contains merged cells.
Test Excel in Safe Mode and disable interfering add-ins
Use this approach if the same commands fail in multiple workbooks or an add-in may be interfering.
Open a different workbook in Excel and try Home > Find & Select or Data > Sort. If the issue occurs only in the downloaded file, inspect its contents and formatting instead.
On Windows, close Excel, hold Ctrl while launching Excel, and select Yes when prompted to start in Safe Mode. Open the affected workbook and test the command again.
If the command works in Safe Mode, restart Excel normally. Go to File > Options > Add-ins, select COM Add-ins in the Manage list, and click Go. Clear one add-in at a time and retest; also check Excel Add-ins in the Manage list if needed.

Check the search settings and workbook structure
Use these checks when the problem appears limited to the downloaded workbook.
Edit and sort downloaded spreadsheets with WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface. Open compatible Excel files in WPS Spreadsheet to search, replace, and sort data while moving between Office applications. It does not repair Excel add-ins.

Frequently Asked Questions
Why does Excel Find miss text that I can see?
Go to Home > Find & Select > Find > Options and check the search scope, Look in setting, Match case, and Match entire cell contents. A setting that is too restrictive can exclude the text.
Can merged cells prevent Excel from sorting?
Yes. Merged cells can prevent a range from sorting correctly. Select the affected cells and use Home > Merge & Center > Unmerge Cells where appropriate, then select the full data range and try Data > Sort again.
How can I tell whether an Excel add-in is causing the problem?
On Windows, hold Ctrl while launching Excel and select Yes to start in Safe Mode. If the command works there, restart normally and disable add-ins one at a time under File > Options > Add-ins.
Will copying data into a new workbook fix the issue?
It can help isolate workbook-specific formatting or structure. Copy the data into a workbook created with File > New, then test the command. Paste Special > Values can exclude formulas and formatting if they are not needed.




