Excel search/replace does not replace

Question

I am running Excel for Mac 16.22 Office 365. Sometimes (not all the time) when I search/replace, Excel reports it has replaced the target text, but nothing changes. I then have to replace each and every occurrence manually. This does not happen all the time, just sometimes. This makes it all the harder to resolve.

Answer 1

Hi oceanswims,

Sorry that we can’t reproduce your Excel issue on our side. And sorry for the troubles caused by this issue. We suggest that you to give us feedback to help us deliver great products. You can Use the feedback tool in the upper-right corner of Excel to send feedback directly to our team.

Appreciate for your understanding.

Best Regards,

Ivy

Answer 2

Hi oceanswims,

Sorry to hear this issue still persists, to further narrow down this issue, can you provide the information below to us：

1 .What contents/characters you want to replace in the file?

2. Does this issue occur in the specific file or other random files?

If this issue occurred in the specific file, can you provide this file through PM to us to reproduce this issue and find the problem?

Regards,

Ivy

Answer 3

Yes, the problem still recurs, although, as I indicated earlier, not all the time; just sometimes, which makes it all the less explicable.

I am running Excel 16.24, and the problem did not occur prior to upgrading to 16.22.

Thanks

Paul

Answer 4

Hi oceanswims,  

Can you use search/replace normally now? Do you still need any help? You are welcome to share with me your updates here.

Regards,

Neo

Answer 5

It baffles me that Microsoft Advisors go for esoteric suggestions, when simple things are easier.

Your software is out of date. Install updates, then test again.

INSTALL UPDATES

Make sure your Mac has a working internet connection before checking for updates. Install Mac OS X updates followed by Office updates.

---

Install Mac OS X updates first:

To get Mac OS updates, go to the App store on your dock, and then click the Updates button to reveal available updates.

---

Then Install Office Updates

To get the update:

IF YOU DID NOT PURCHASE OFFICE FROM THE APPLE MAC STORE:

1. Open any Office application
2. Go to the Help menu and choose Check for Updates
3. Let AutoUpdate check for and install updates
4. Restart your Mac

IF YOU OBTAINED OFFICE FROM THE MAC STORE

1.     On your dock, click the App Store icon

2.     Click the Updates tab

3.     Install Office updates

If you have any add-ins such as WebEx, Mendelay, EndNote, Zotero, TypeIt4me, etc it is essential that you install the latest updates for your add-ins. This includes font management add-ins, such as Suitcase. If you use Suitcase, you should have at least version 9.