Topic: EXCEL communication Search

Hello world!
At discovery EXCEL of a file I receive the message on impossibility to update a certain communication.
Prompt as it to find?


Re: EXCEL communication Search

To look among formulas, among names, in conditional formatting.


Re: EXCEL communication Search

And how to search in conditional formatting?


Re: EXCEL communication Search

To search in rules - suddenly somewhere the formula what refers to a range or a name in other book. Such happens, if cells are copied from other books with formats.
Plus it is possible to look even among connections (the tab for the data - Inquiries and Connections).


Re: EXCEL communication Search

Well and generally at you Excel shows where to search for the source file on which communication remained - disk R-Common - something somewhere "001 Task on automation "


Re: EXCEL communication Search

Thanks for your councils and explanations.
In my case the problem was in formulas on one of sheets.
I did not know, Ctrl+F by default searches on current sheet.
Changing search setup, under all book, I found problem cells and corrected in them formulas.