Find and Replace Question

%3CLINGO-SUB%20id%3D%22lingo-sub-3243071%22%20slang%3D%22en-US%22%3EFind%20and%20Replace%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3243071%22%20slang%3D%22en-US%22%3E%3CP%3EI%20keep%20running%20into%20an%20issue%20when%20using%20the%20find%20and%20replace%20function.%20Sometimes%20it%20works%2C%20sometimes%20it%20doesn't%2C%20and%20when%20the%20find%20and%20replace%20doesn't%20work%2C%20the%20pop%20up%20notification%20says%20%22it's%20possible%20the%20data%20you're%20trying%20to%20replace%20is%20in%20a%20protected%20sheet.%20Excel%20can't%20replace%20data%20in%20protected%20sheets%22.%20However%2C%20I've%20checked%20the%20info%20tab%20and%20the%20access%20is%20unrestricted%2C%20and%20I've%20checked%20the%20Review%20tab%20and%20the%20sheet%20has%20never%20been%20protected%20when%20this%20occurs.%20Can%20you%20please%20help%20in%20diagnosing%20the%20problem%20I%20keep%20having%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3243071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3245226%22%20slang%3D%22en-US%22%3ERe%3A%20Find%20and%20Replace%20Question%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3245226%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1322290%22%20target%3D%22_blank%22%3E%40palinkalo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20you%20do%20the%20find%2Freplace%20within%20the%20whole%20workbook%2C%20could%20it%20be%20that%20there%20are%20some%20hidden%20sheets%20(which%20might%20be%20protected%20as%20well)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I keep running into an issue when using the find and replace function. Sometimes it works, sometimes it doesn't, and when the find and replace doesn't work, the pop up notification says "it's possible the data you're trying to replace is in a protected sheet. Excel can't replace data in protected sheets". However, I've checked the info tab and the access is unrestricted, and I've checked the Review tab and the sheet has never been protected when this occurs. Can you please help in diagnosing the problem I keep having?

 

Thanks!

1 Reply

Hi @palinkalo 

 

if you do the find/replace within the whole workbook, could it be that there are some hidden sheets (which might be protected as well)?