Office Compatibility Issues

Fix Find and Replace or Sort in Excel Files from Google Drive

Huma Ashraf ChHuma Ashraf Ch Nov 22, 2026 868 views

Question details

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

Fix Find and Replace or Sort in Excel Files 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.
Before you start

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.

Solution 1Recommended

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.

1
Test another workbook

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.

2
Start Excel in Safe Mode

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.

3
Disable add-ins one at a time

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.

Test Excel in Safe Mode and disable interfering add-ins
Safe Mode availability: The Ctrl-launch Safe Mode procedure applies to Excel on Windows. Add-in settings and troubleshooting options may differ on other platforms.
Free Microsoft Office alternative

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.

Find, replace, and sort spreadsheet data in WPS SpreadsheetOpen and edit compatible Microsoft Excel XLS and XLSX filesUse a familiar interface for an easier transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

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.