Q. When I link two sheets together and a cell in the source sheet is blank, I get a 0 in the target sheet. How do I get rid of the 0’s?
A. If you don’t have a valid 0 value in a cell, there is an Option under Advanced, you can set for a particular worksheet called “Show a zero in cells that have zero value." It is specific to that workbook and that worksheet in that workbook.