1

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?

2

Re: EXCEL communication Search

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

3

Re: EXCEL communication Search

And how to search in conditional formatting?

4

Re: EXCEL communication Search

Yagrus2;
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).

5

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 "

6

Re: EXCEL communication Search

The_Prist;
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.