Home

Find and Replace not working in Protected Excel Workbook (for unlocked cells)

%3CLINGO-SUB%20id%3D%22lingo-sub-197936%22%20slang%3D%22en-US%22%3EFind%20and%20Replace%20not%20working%20in%20Protected%20Excel%20Workbook%20(for%20unlocked%20cells)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-197936%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20noticed%20a%20new%20issue%20in%20the%20desktop%26nbsp%3Bversion%20of%20excel%20(v16.13.1)%20-%20I%20am%20working%20on%20Mac.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20protected%20workbook%20with%20protected%20sheets%20and%20some%20unlocked%20cells%20which%20contain%20plain%20text.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20the%20older%20version%20(before%202018)%20I%20was%20able%20to%20still%20use%20find%20%26amp%3B%20replace%20to%20quickly%20correct%20mistakes%20in%20these%20text%20cells%2C%20even%20though%20the%20overall%20workbook%20was%20locked%20(and%20sheet%20was%20protected)%20-The%20cells%20I%20want%20to%20be%20able%20to%20edit%20are%20unlocked%20and%20can%20be%20edited%20by%20clicking%20into%20them%20one%20by%20one.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20the%20new%20update%2C%20I%20can%20no%20longer%20use%20find%2Freplace%20or%20the%20spell%20check%20option.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20this%20is%20an%20update%20oversight%20and%20will%20be%20fixed%20soon!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-197936%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharing%20%26amp%3B%20Publishing%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Simon Kuznetsov
Occasional Visitor

I have noticed a new issue in the desktop version of excel (v16.13.1) - I am working on Mac. 

 

I have a protected workbook with protected sheets and some unlocked cells which contain plain text. 

 

With the older version (before 2018) I was able to still use find & replace to quickly correct mistakes in these text cells, even though the overall workbook was locked (and sheet was protected) -The cells I want to be able to edit are unlocked and can be edited by clicking into them one by one. 

 

Since the new update, I can no longer use find/replace or the spell check option. 

 

I hope this is an update oversight and will be fixed soon!

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies