Software

Ask something
Discussion Locked

Locked Excel can not use Find command

0 helpful
5 replies

by nevernessit

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all, and thanks in advance.

I'm having an issue with a spreadsheet here at work that has been protected by another person. I can access the spreadsheet and read its contents, but the find command does not work. When I try to find something in the document it says Microsoft Office Excel can not find the data your searching for.

Is there anyway around this besides removing the protection on the spreadsheet?

Thanks very much.

5 replies

by neil_essex

You need to select each sheet, set the filter criteria to Show All, and then perform the search.

To show all data in a filtered list, on the Data menu, point to Filter, and then click Show All.

Hope this works, it did when someone locked our sheets at work.

by nevernessit

The data cant be filtered as the spreadsheet is protected. I get no options under the Data>Filter menu

This discussion is closed to new replies.