In the destination sheet, click the cell where the upper-left cell of the range should be located and click Paste Paste Link on the Home tab. You should see a new sheet with all the issues listed out. To link a range of cells, select the cells and click Copy. In the Compatibility Checker dialog box click the Copy to New Sheet button

In the Info section, select the Check for Issues drop-down Subtotal will still be correct because you used the cell address rather than the value in the formula.

Using The Compatibility Checker to Find Data Validation Errors: Now, if you change a price or quantity, the. Lets say that I have a master sheet of all technical support questions posed in 2013, with a column called Assigned To. You can manually search through each of your Data Validation rules within your workbook however, that may be a daunting task if you have a lot of tabs to search through.В An easier way is to use the Compatibility Checker to search for you. I want on my column link to put a link that can bring me to the corresponding logistic process (so for example the cell A1120) without having to open the two streams at the same time by myself before clinking on the link. For example, in maintenance I have a process called process inbound flow, it is a logistic one. This can occur as the Source input for a List rule. I want to put in this one a link that can bring me to the corresponding cells. Removing External Links From Data Validation RulesД®xternal Links can reside in Data Validation rules. Microsoft Office and Microsoft Internet Explorer are tightly integrated, and your digital signature must be imported into Internet Explorer before it can be.

How to link cells in excel 2010