I have created a search formula in Excel which gives back a text if it is found.
After creating, it actually gives back the text I expect, so it works. The issue is the following:
When closing the file and the file is used by other users sometimes the field does not gives back anything. This is without any change in the field containing the search or the data which is to be checked.
When I open a previous version of the file from the version history, the field works as expected, but after replacing the the current one with the older version the fields suddenly become blank (only the output, the search formula is still in there).
Maybe it has something to do with the settings of the other users. Does anybody recognize this problem and knows how to solve it?
